Tom Kyte

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

PLSQL Code type native compilation

Mon, 2016-08-22 21:46
Hi Tom, what are the pros and cons if I convert my plsql code type to Native? I have package bodies, procedures & functions where most of my code runs. I do have lot of data extractions taken from DB & number of PLSQL programs that run for hours....
Categories: DBA Blogs

Copying data from one environment to other

Mon, 2016-08-22 21:46
Hi, what is the best way to copy data from one environment (PRD) to other environment (NON-PRD) in oracle installed on UNIX server? Thanks, DIPU
Categories: DBA Blogs

Uncommited changes in data files?

Mon, 2016-08-22 21:46
Hi, While i was studying "Instance Recovery" topic in the "Oracle 11g Concepts" document, i read something something like this; "When a transaction is committed, log writer (LGWR) writes both the remaining redo entries in memory and the transac...
Categories: DBA Blogs

Sequence.nextval not working in sqlldr

Sun, 2016-08-21 09:06
sequence.nextval not working when i am using in sqlldr , sqlldr loading null value in DB Snapshot of my control file load data append into table Selectiotab WHEN (1:2) <> 'H|' and (1:2) <> 'T|' fields terminated by "|" trailing nullcols ( ...
Categories: DBA Blogs

As a DBA how to verify if private database link is functional

Sun, 2016-08-21 09:06
Hi, Being a DBA, how can we verify if private database link created in application schema is working fine? If application schema's password is not known to DBA. We can verify public database link using select * from dual@public_db_link; How pri...
Categories: DBA Blogs

HOW TO TAKE BACKUP OF A TABLE WHICH IS BELONGS TO DBF FILE. AND IS IT SAFE TO DO THAT FOR APPLICATION

Sun, 2016-08-21 09:06
HELLO SIR, my name is bhargav reddy from Bangalore, actually i am a student, i want to know how to take backup of .DBF file which is belongs to live application, so please tell me the process to do that and one more thing that is it safe to take ...
Categories: DBA Blogs

Notification mail from database server

Sun, 2016-08-21 09:06
Hi team, I have manually check the tablespace size daily basis now i want to configure the script which check the tablespace size and if the size is less than 10GB then it will send a mail to mai Id So, Which things we need to configure on ser...
Categories: DBA Blogs

Error while trying to retrieve text for error ORA-01804 12c occi c++ application on ubuntu

Sat, 2016-08-20 14:46
Hello every one please help me after installing oracle 12c in ubuntu 16.04. I am try to check by simple c++ occi connection code,but from my code at create environment :- env = Environment::createEnvironment(Environment::DEFAULT); display error like:...
Categories: DBA Blogs

Migration from 9i to 12c Pro*C server application.

Sat, 2016-08-20 14:46
We are migrating or legacy 32 9i Pro*C server code over on to a new Oracle Solaris 11 Unix and Oracle 12c server. Can we run the legacy 32 legacy code running on the 32 bit server pointing to the new 12c database server? Oracle will be doing the ...
Categories: DBA Blogs

ORA-04052: error occurred when looking up remote object FPL.COIMREGI@FPL

Sat, 2016-08-20 14:46
Hi, I have a problem when I try to compile a function in a database oracle 9.2.0.8, and I got this error: PL/SQL: ORA-04052: error occurred when looking up remote object FPL.COIMREGI@FPL ORA-00604: error occurred at recursive SQL level 1 OR...
Categories: DBA Blogs

Recieving error ORA-01460: unimplemented or unreasonable conversion requested when running sp to update a clob field.

Sat, 2016-08-20 14:46
I have written an SP, based on the posts I have read on your site, which is designed to take the text (originally from script files) and update an existing record containing a CLOB field. This works fine with the text from smaller files, but when I t...
Categories: DBA Blogs

Setting up lower environment

Sat, 2016-08-20 14:46
Hi, I'm looking for a solution/best approach to set up my lower environments from Production with pared down version, say 90-100% data for UAT, 30% for SIT and 10% for Dev environments. Can you suggest an approach to achieve this at schema level? ...
Categories: DBA Blogs

Using SYS.REFCURSOR out variable as a source for classic report in ORACLE APEX.

Sat, 2016-08-20 14:46
Hi , I have a urgent requirement, I have been struggling through it alot. WE have a package created in database which is having a procedure with (5 input variables and 1 out variable (which is a sys refcursor). Now the rason why we have used...
Categories: DBA Blogs

Creation of a dynamic database trigger on a table

Fri, 2016-08-19 20:26
Hi Tom, I had asked a similar question earlier this month. For some reason, it is not letting me reply or update the same thread. Hence opening a new one. I wanted to provide additional details on my question and request your help. The requ...
Categories: DBA Blogs

Analytical question

Fri, 2016-08-19 20:26
Hi Tom, I have a PATIENT table with (fName, lName .... ETHNICITY, GENDER.) Another table XXX with some medical data. <b>I want to get the % of HispanicFemales% of total record in xxx table and the HispanicFemales% of Hispanic Ethnic in xxx tabl...
Categories: DBA Blogs

How can i measure thread usage in a 11g standard edition database

Fri, 2016-08-19 20:26
We have an 11g standard edition database. We are being faced with an upgrade to 12c standard edition 2 with its inherent thread limit. Within my database I can see sockets, cores and cpu usage but I need some advice on how this relates to the thread ...
Categories: DBA Blogs

Hybrid Histogram

Fri, 2016-08-19 20:26
Team, Was reading about Hybrid histogram from documentation <u>http://docs.oracle.com/database/121/TGSQL/tgsql_histo.htm#TGSQL372</u> <code>demo@ORA12C> create table t as select * from all_objects; Table created. demo@ORA12C> column ow...
Categories: DBA Blogs

XML Parse error due to escape characters

Fri, 2016-08-19 20:26
Hi Tom, We have a process wherein we try to consume the XML and store it in a table as CLOB . These XMLs which we are getting are having the escape characters like '&' or '<' in the text part of the XML. When we try to parse the XML using XMLt...
Categories: DBA Blogs

insert only value of rows which has data from tabular form into database

Fri, 2016-08-19 20:26
Hello can you please help me how to create a PL/SQL process to insert only rows which has values from tabular form into database,not those rows which does not have value, below is the insert PL/SQL process that i created, but it insert empty rows al...
Categories: DBA Blogs

How to automatically execute sql queries in SQl developer

Fri, 2016-08-19 02:06
Hi thatjeffsmith, I'm from Vietnam. I have a trouble need your help I want to run this queries in SQL developer automatically, frequency will be daily: spool D:\test.csv select /*csv*/ * from dwh.DEPARTMENT_TCB where rownum <= 10 / spool o...
Categories: DBA Blogs

Pages