AskTom - Hot Questions

Subscribe to AskTom - Hot Questions feed AskTom - Hot Questions
These are the questions on Ask Tom that have the most comments
Updated: 14 min 46 sec ago

Expdp and impdp

Tue, 03/14/2017 - 00:00
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?

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

Mon, 03/13/2017 - 00:00
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...

Advanced Compression Options in Oracle 11g

Fri, 03/10/2017 - 00:00
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...

Retreive rows of primary key in batches

Mon, 03/06/2017 - 00:00
I want to fetch a 80Million table, due to performance constraints, I want to process the data in batches(5000), i want to get the firstKey and lastKey for each batch. Each batch has 5000 unique Id records. Example of output:- BATCH_ID FIRS...

Daily Insert, Delete on table

Mon, 03/06/2017 - 00:00
I have a table tb_card_data CARD_NO TYPE EMAIL MODULE CREATED_ON SEQ_NO ------- ---- ----- ------ ---------- --------- 12345 C MOD_1 06/03/2017 20170306000001 (create_on + sequence number) .. so on around 500k records for MOD...