Tom Kyte

Subscribe to Tom Kyte feed Tom Kyte
These are the most recently asked questions on Ask Tom
Updated: 3 hours 16 min ago

crs processes

Tue, 2018-02-13 06:26
when we start CRS which process will start first and explain its background
Categories: DBA Blogs

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

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

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

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

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

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], [], [], [], [], [], [], [], [], []

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

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

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

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

Active Schema objects

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

instance,Database&DB Components.

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

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

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?

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

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 -

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

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

external jobs with dbms_scheduler ORA-27369 exit code Bad address

Thu, 2018-02-08 16:06
Hello, I have this job (EXECUTABLE) that exec a bash script. Here's a resume of what it does connect to a FTP server, get a file, call a pkg via sqlplus using the files as external table in order to import data. The job fails with 'ORA-27369:...
Categories: DBA Blogs

Does a sys ref cursor have performance overheads

Thu, 2018-02-08 16:06
Hello, Currently I'm working on a procedure which returns data (big volume of data) to a calling procedure (java). The pl/sql procedure opens a sys ref cursor like pr_get_transactions ( i_from_date IN DATE ,o_transactions...
Categories: DBA Blogs

Pages