Tom Kyte

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

Oracle Utilities ( SQL Loader) for Ubuntu

Thu, 2016-12-08 12:06
I need to install SQL Loader in ubuntu to access the Oracle 12c r1 on different box. My understanding is that Ubuntu is not certified for Oracle . Want to confirm my understanding . If yes , please provide the link to install instructions.
Categories: DBA Blogs

Double quotes found on the cloud which are not in the create script

Thu, 2016-12-08 12:06
Mr. Kyte... We have purchased a few instances of Oracle 12c in the cloud and most recently have encountered a curious double quoting in our tables. create table t_is_it_quoted ( is_this_text_quoted varchar2(20) ); when we look at...
Categories: DBA Blogs

Insert/update table based on condition

Thu, 2016-12-08 12:06
We have 2 tables one having 4 columns and second has 2 columns. Create table A(Currency_old varchar(20),Currency_indicator_old varchar(20),Currency_New varchar(20),Currency_indicator_new varchar(20)); Create table B (Currency_old varchar(20),C...
Categories: DBA Blogs

DML operations in before/after trigger

Thu, 2016-12-08 12:06
SQL> CREATE OR REPLACE package DB_ADMIN.TRI_pkg is 2 type t_dblogin is table of t1%rowtype index by pls_integer; 3 type t_audit is table of audit_tab%rowtype index by pls_integer; 4 5 v_dblogon tri_pkg.T_DBLOGIN; 6 v_audit tri_pkg.t_audit; ...
Categories: DBA Blogs

SQL Loader to load multiple tables from CSV input file

Thu, 2016-12-08 12:06
I have data file which has comma separated values : col1,col2,col3,col4,Key1,Value1,Key2,Value2,Key3,Value3............ Requirement is to load col1-col4 inTab1(col1,col2,col3,col4) AND second part of data is key/Value pair, number of key/value...
Categories: DBA Blogs

Non-pipelined table function with dynamic sql statement

Thu, 2016-12-08 12:06
Hello, Ask Tom Team. Would you mind telling me how I can create table function without pipelined option (I think that it unnecessary, because I have not a big data in it) in a package level using dynamic sql and table of records collection. I know ...
Categories: DBA Blogs

Can we update a locked row column in other session ?

Thu, 2016-12-08 12:06
Hi Tom, I have created one table for example like CREATE TABLE reservation ( Reservation_Id NUMBER, Reservation_number NUMBER ); INSERT INTO reservation (Reservation_Id, Reservation_number) VALUES(1, 100001); INSERT INTO reservat...
Categories: DBA Blogs

Change Decimal pointer

Thu, 2016-12-08 12:06
Hi, Please inform how can replace decimal operator dot(.) with comma(,) in oracle database Permanently I want to change it in database. Also no separator is required for numaric values.All decimal fields of table will accept comma(,) i...
Categories: DBA Blogs

How to use Clob parameter inside dynamic sql statement to execute immediate

Thu, 2016-12-08 12:06
Hello, Ask Tom team! There is my problem. i have a package procedure with some parameters: procedure updt(p_col varchar2,p_value clob) is v_update_clob clob; begin v_update_clob:= 'update table set :p_col=:p_value where cond = ''some_conditi...
Categories: DBA Blogs

Retrieving DBMS_OUTPUT.put_line from JDBC?

Wed, 2016-12-07 17:46
I'm using a Java application to process an incoming feed. The app inserts data into some Oracle tables, then runs an Oracle stored procedure. The Java application is called from a UNIX script, connects to Oracle using Oracle's thin client driver an...
Categories: DBA Blogs

index issue with our partitioned table ora14196 and question if plan OK?

Wed, 2016-12-07 17:46
Hello Tom I have an index issue with our partitioned table this table cw_tb_zvlist11 has about 500 mio rows inserted and the insert process is still active I see that unfortunality we created the primary index as a nonunique one. Now I tr...
Categories: DBA Blogs

adding column with default value 0

Wed, 2016-12-07 17:46
Hi Tom, I have read lot of posts which you have discussed on the subject of adding column with some default value. Thanks a lot for such a great service you render to oracle community. Unfortunately one of my friend informed me some bugs are as...
Categories: DBA Blogs

Is there another option for Next Value For

Wed, 2016-12-07 17:46
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production How would I go abo...
Categories: DBA Blogs

Flashback Archive Internal History table is not compressed -- Kindly suggest

Tue, 2016-12-06 05:06
Hi Tom, Once flashback archive is enabled for a table, a corresponding history table will be created by oracle internally. It is automatically partitioned and compressed as well. But when I have enabled FBA for a table, the history table is partit...
Categories: DBA Blogs

Column with default value

Tue, 2016-12-06 05:06
I have a table in which one of the column is as below create_date TIMESTAMP(6) default SYSDATE, When the record is inserted from the GUI(URL) , it doesn't insert any value for create_Date .. But when inserted from other than URL i...
Categories: DBA Blogs

Redo Log 4K Blocksize

Tue, 2016-12-06 05:06
Good Evening, In 11g, I've read about the possibility of setting redo logs to have a blocksize of 4k. Supposedly, the blocksize is automatically set based on the block sector of the disk. Supposedly, high capacity disks have block sectors of 4k....
Categories: DBA Blogs

SQL profile is usable?

Tue, 2016-12-06 05:06
Hi,guy! I have some question about the SQL PROFILE, when use SQL PROFILE to bind the SQL,it performanced good,but as time goes by,the data in the table will grow rapidly and the SQL which use SQL PROFILE performanced bad. So what's the meaning of th...
Categories: DBA Blogs

db2 Query in Unix: load from /dev/null of del replace into Schema.Tablename nonrecoverable;

Tue, 2016-12-06 05:06
Hi Tom, In Unix db2 I am using the below query to clear the table. db2 Query in Unix: load from /dev/null of del replace into Schema.Tablename nonrecoverable; What would be the best approach to do the same thing in Oracle. I don't thin...
Categories: DBA Blogs

How mandatory is to use DBMS_AUDIT_MGMT

Tue, 2016-12-06 05:06
Hello everyone, One question please, how mandatory is to use the package DBMS_AUDIT_MGMT for Oracle. a)There is a NOT ADVISABLE suggestion from Oracle to work in aud$ table directly, to force to use ALWAYS the package. b) is simple we ADVISE ...
Categories: DBA Blogs

Latch Free

Tue, 2016-12-06 05:06
Hi Connor, I have no intention of complaining. But all over the web I find lot of discussion about latch , latch spin, and latch sleep. And the description goes like below. 1] Try to acquire a latch 2] Failed ! Try again after sometime 3] Ret...
Categories: DBA Blogs

Pages