DBA Blogs

Using defined variable (ampersand) for a part of column name

Tom Kyte - Tue, 2018-02-13 06:26
Good day. I am having problem to define <b><u>only part</u></b> of a column name as a variable (using ampersand). Script example: <b><i>Select &Product._ID, &Product._NAME, &Product._SALES, &Product._DEBT From TABL...
Categories: DBA Blogs

In- Memory option versus buffer cache

Tom Kyte - Tue, 2018-02-13 06:26
Hi Team, can you provide some information regarding in-memory database ? As per my understanding i see that it works in same way of keeping object in buffer cache like keep pool etc. in-memory is also provide same functionality .So , why i s...
Categories: DBA Blogs

substr operation

Tom Kyte - Tue, 2018-02-13 06:26
hi there, select substr('hellooracle',1,2)from dual;--> this will return 'he' select substr('hellooracle',3,4)from dual;-->this will return 'll' my question is i want to cut the entire string in a given order(for the above example it will like 1,...
Categories: DBA Blogs

Row count of tables

Tom Kyte - Tue, 2018-02-13 06:26
Hi Tom, Recently I have experienced something weird about table row count after gather stats the table. At first I have checked count(*) and num_rows from one table. Then count(*) shows 651 rows and num_rows shows 2211 rows. So I have do...
Categories: DBA Blogs

Reg: Masking Sensitive column data

Tom Kyte - Tue, 2018-02-13 06:26
Hi TOM I have a requirement of masking sensitive data as we have to refresh production data to development environment. I have gone through a couple of options ,Data masking through enterprise manager and through vpd policy. The actual requir...
Categories: DBA Blogs

3rd party tool fails with: ORA-00600: internal error code, arguments: [kdu_array_buf:depth], [17], [16], [], [], [], [], [], [], [], [], []

Tom Kyte - Tue, 2018-02-13 06:26
Hi TOM, that is the error that we get: SQL: UPDATE /*+ PARALLEL */ POM_BACKPOINTER SET to_class = 1546 WHERE to_uid IN ( SELECT puid FROM ao_temp ); ERROR: ORA-00600: internal error code, arguments: [kdu_array_buf:depth], [17], [16], [],...
Categories: DBA Blogs

Sequence no mismatch between Primary and Standby

Tom Kyte - Tue, 2018-02-13 06:26
Hi, I have taken backup from primary database that time the max sequence number was 285 which was applied on standby. after few minutes had an issue in standby database so that i dropped standby database permanently. so here what i done..restored ...
Categories: DBA Blogs

SP2-0606 when use dynamic spool path

Tom Kyte - Tue, 2018-02-13 06:26
SQL*Plus client : Release 11.2.0.1.0 on Windows 8 client writing output in Spool file with hardcoded path is working in any directory, but with spool &filename with and without doublequotes around that string I get the message <b>SP2-0606: Kann ...
Categories: DBA Blogs

DBMS_PARALLEL_EXECUTE for create table as select

Tom Kyte - Tue, 2018-02-13 06:26
Hi Tom, I am trying to make use of this package at some SE 12.2 and 11.2 databases we have our customers' data. What I have already read about, always shows how to make chunks of a table object. I would like to usae it with the result of a c...
Categories: DBA Blogs

Lift & Shift Oracle Apps & SAP Applications to Oracle Public Cloud - Webcasts Bundle

Focused on providing all the latest information on Oracle Cloud for Oracle Partners, here is a quick reference of Partner focused Webcasts for moving Oracle Applications Unlimited (EBS , Siebel...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Virtual Workshop - Security Monitoring & Analysis (SMA) - Configuration & Compliance ...

Security Monitoring and Analysis (SMA) and Configuration Compliance Cloud Services @OMC Tuesday, February 20, 2018 ...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Active Schema objects

Tom Kyte - Sat, 2018-02-10 04:46
How to find a list of active views in an Oracle schema? The dba_objects, all_views and other sys tables included the dropped views as well, but we would like to get active list.
Categories: DBA Blogs

The Transition (or: How I Learned to Stop Worrying and Love PostgreSQL)

Don Seiler - Fri, 2018-02-09 14:31
Note: Yes I re-(ab)used the title.



As some of you may know (if you follow me on twitter), after 16 years as an Oracle DBA, I made a career shift last summer. I hung up the Oracle spurs (and that sweet Oracle Ace vest) and threw on a pair of PostgreSQL chaps. I had always been a fan and very casual user of PostgreSQL for many years, even gently lobbying the folks at Pythian to add PostgreSQL DBA services to their offering (to no avail).

I'm taking this fresh start to also jump-start my blogging, hoping to write about interesting notes as I dive deeper in the PostgreSQL world (and even some Hadoop as I get into that). I'm just over 6 months into my new adventure and loving it. I'm excited to be dealing a lot more with an open source community, and interacting daily with some contributors via Slack.

Over the past 6 months, I've compiled a list of topics to write about. If I can remember the details or find my notes, I'll hopefully be writing regularly on these topics!

So, I hope to see more of you regularly here. Stay tuned!
Categories: DBA Blogs

instance,Database&DB Components.

Tom Kyte - Fri, 2018-02-09 10:26
Hi, I know the difference between Instance and Database. but i have few doubts about version of Instance and Data Base. 1). Can the versions be different for Instance and Database or they must have same version. 2). i did not understand what ar...
Categories: DBA Blogs

EXTPROC querying Oracle User

Tom Kyte - Fri, 2018-02-09 10:26
I've been using EXTPROC functions for a while but recently came across a use case that requires one to determine if the EXTPROC call should have access to external resources based on who the calling Oracle user is. The first thing that comes to mi...
Categories: DBA Blogs

expdp command subquery

Tom Kyte - Fri, 2018-02-09 10:26
Good Morning..!! Q: I've come up with a requirement where I will need to do table export where status ='YES'. My requirement is to get this WHERE clause from input table into variable and put it at expdp command in shell script Ex: SELECT...
Categories: DBA Blogs

Does a 10g oracle client work with 12.2c server?

Tom Kyte - Fri, 2018-02-09 10:26
Does a 10g oracle client work with 12.2c server?
Categories: DBA Blogs

Table Level Privileges for Read Only Access

Tom Kyte - Thu, 2018-02-08 16:06
Hi, I have new DB installed and configured by sys user. then i will execute following script to create new schema identified by CS4 <i>create user cs4 identified by cs4; grant connect to cs4; grant create session to cs4; grant dba to cs4;...
Categories: DBA Blogs

Issues with a query returning occasionally a ORA-00932: inconsistent datatypes: expected - got -

Tom Kyte - Thu, 2018-02-08 16:06
Dear Tom-successors, I have a problem which I cannot track down as it seems to happen randomly. First of all, I'm using: <code>Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production...
Categories: DBA Blogs

Best Practice to convert 400 million rows table with 3 TB of CLOB to partition table

Tom Kyte - Thu, 2018-02-08 16:06
Hi, I am converting a non-partitioned table to Partitioned(range or Ref). For test scenario, I have a table with 50 GB data (300 million rows) and 100 GB CLOB column data. I tested below options and timings are not as per my satisfaction level. 1. ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs