DBA Blogs

Updating a duplicate row based on previous row.

Tom Kyte - Wed, 2017-03-15 11:46
Now i got a scenario today where i need to update the duplicate row created in the table. I knew that would be easy but there was a trick in this scenario. The duplicate is considered only when you look into two rows and some column combination. <...
Categories: DBA Blogs

Oracle AQ for asynchronous search

Tom Kyte - Wed, 2017-03-15 11:46
Hello, Tom. I have a pretty long question with, I suppose, pretty short answer required. I need to develop a solution for asynchronous search in the database. Being not experienced with Oracle Advanced Queuing, I read something about this mechan...
Categories: DBA Blogs

expdp and impdp

Tom Kyte - Wed, 2017-03-15 11:46
Hi Tom, I have export the schema for testing as: expdp test/test directory=test_dir dumpfile=tbltest1.dmp logfile=tbltest1.log schemas=hr done now i'm trying to import just only specified rows from the dump file as impdp test/test direc...
Categories: DBA Blogs

Character Set

Tom Kyte - Wed, 2017-03-15 11:46
Hi, I would like to know about the Character sets Purpose,need of them In Data Base?
Categories: DBA Blogs

TEMP_UNDO_ENABLED and with clause

Tom Kyte - Wed, 2017-03-15 11:46
Hi I do like to use 'with' syntax (common table expressions) in long select statements. To me they make statements much more readable. While looking at that execution plans one notices that sometimes these statements are using internal tab...
Categories: DBA Blogs

Extract only "executable" SELECT code block within a very long SQL Text string that contains comments

Tom Kyte - Wed, 2017-03-15 11:46
Hello, I have a column of type CLOB in a table, where a user could copy-paste their entire "SQL Query Text" string so that a procedure will later "process" the entries in this table and use DBMS_SQL to parse out the query string to see if it is va...
Categories: DBA Blogs

datafile, tablespace

Tom Kyte - Wed, 2017-03-15 11:46
Hi Tom, I have create a tablespace test01 with datafile as '/u01/app/oracle/oradata/test01.dbf', also create one table test01 with tablespace test01, insert data into table test01, and commit. Than without alter tablespace, from os level i have mo...
Categories: DBA Blogs

Oracle EMEA Infrastructure & IaaS Partner Community Forum 25th-26th April 2017

The 2017 Oracle EMEA Infrastructure & IaaS Partner Community Forum will be  taking  place on 25th and 26th April in Malaga, Spain. Come learn and share your experiences to extend IT...

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

12.2 Moving Tables Online (Real Cool World)

Richard Foote - Wed, 2017-03-15 01:41
One of the really cool new features introduced in Oracle Database 12c Release 2 is the capability to MOVE tables ONLINE, while maintaining all the associated index structures. This was possible for table partitions in Oracle Database 12c Release 1 but only for Indexed Organized Tables before then. Rather than show a demo that just moves a table, […]
Categories: DBA Blogs

Advanced Compression Options in Oracle 11g

Tom Kyte - Tue, 2017-03-14 17:26
Hi Chris/Connor, Can you please share any document on Advanced Compression Options in Oracle 11g. I have searching on this and getting only theoretical stuffs. Could you please share any reference, blog to study on this to understand its use on OL...
Categories: DBA Blogs

Umlaut characters converted to junk while running PL/SQL script

Tom Kyte - Tue, 2017-03-14 17:26
Hi, I have procedure with umlaut characters in it. Below is the sample. CREATE OR REPLACE PROCEDURE procPrintHelloWorld IS BEGIN DBMS_OUTPUT.PUT_LINE('? a A, O, U, a, o Hello World!'); END; / When procedure is created through sql ...
Categories: DBA Blogs

Expdp and impdp

Tom Kyte - Tue, 2017-03-14 17:26
I have a requirement to export a full database using EXPDP and import only three schemas using remap_schemas to a different schema than the original. How can I achieve that?
Categories: DBA Blogs

Clarification of "snapshot too old" error message

Tom Kyte - Tue, 2017-03-14 17:26
Hi, I was going through Tom's book and came across "snapshot too old" section. In the section small undo tablespace is created and below block is run. Below block generates error message "snapshot too old". As per my understanding,the column values...
Categories: DBA Blogs

Web Service

Tom Kyte - Tue, 2017-03-14 17:26
A client of mine asked me posted one or more plsql functions as webservice. Which oracle tool should I use? Thanks from Italy Hi Connor, "posted" is a mistake. They want to access them via web service. Sorry for my poor english. Mass...
Categories: DBA Blogs

Reclaim the free space by truncate/Drop partition from partition table having LOB column

Tom Kyte - Tue, 2017-03-14 17:26
Hi Team, I have one partition table having almost 300GB data with LOB column which contains the 90-95% data of total table size. Partition table having 130 partition created and out of it currently 20 partition having the data. Partition table hav...
Categories: DBA Blogs

db_link and synonym

Tom Kyte - Tue, 2017-03-14 17:26
Hi Tom, I have two databases <b>wombat</b> and <b>foo</b>. Womabt has two users craig and denver. I have created a private db_link with the same name in each users of <b>wombat</b> to connect to <b>foo</b> as follows : owner DB_LINK ------ ...
Categories: DBA Blogs

ORA-12547: TNS: lost contact error in ORacle Linux 7.x

Tom Kyte - Tue, 2017-03-14 17:26
Hi, I am running Virtualbox in Mac OS (sierra) . In VB, i have installed Oracle LInux 7.x as guest OS. In guest OS i am trying to install Oracle 12c. After installing the software, I try to create a database using the dbca command. On running ...
Categories: DBA Blogs

Redo log, why minimum of 2

Tom Kyte - Tue, 2017-03-14 17:26
Hi Tom, Please let me clear that why the mini redo log groups is 2?/ Regards, Gyan
Categories: DBA Blogs

UTL_FILE FRENAME between 2 mounted directories

Tom Kyte - Tue, 2017-03-14 17:26
My question has been asked already at https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:9533980100346684832 Anyway I cannot understand why I can create in that directory a file using FOPEN, why I can copy it, why I can remove it ...
Categories: DBA Blogs

UTL FILE FRENAME (mv) doesn't work - ORA-29292

Tom Kyte - Mon, 2017-03-13 23:06
I have a a shared sftp directory mounted \xx.xx.xx.xx\SFTP_AX\ /sftp/ cifs user,uid=54321,gid=54321,suid,username=user,password=pass,workgroup=application,file_mode=0775,dir_mode=0775,rw 0 0 Then a PL/SQL that moves my file to another mounted dir...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs