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: 2 hours 24 min ago

Time needed to move 1 datafile from 1 diskgroup to another in ASM.

Tue, 01/07/2020 - 00:00
Hi,we have 1 TB datafile in a diskgroup with normal redundancy. We are planning to move that datafile to another diskgroup with external redundancy. The reason for that is because we have a huge diskspace consumption and if we get rid of redundancy, ...

Tablespace TDE & RMAN Backups

Tue, 01/07/2020 - 00:00
Through attrition our team has lost the password to the Oracle Keystore (Wallet) on our current Oracle 12c database(A). We would like to backup this database and restore it to a new instance(B) which is also 12c. The database(A) contains TDE Tablespa...

Strange behaviour of Automatic Memory Resize

Wed, 12/18/2019 - 00:00
Hi, we are facing a strange issue behaviour with our database, we are encountering ORA-04031 error. ---------------------------------------------------------------------------------------------------- ORA-04031: 56 Byte des Shared Memorys konn...

xTTS Oracle Data migration from big endian to little endian

Wed, 12/18/2019 - 00:00
Hi Tom, We have a SAP Oracle database with large no. of objects count. DB Size is less which is around 500GB. But tables count is 75000, indexes are around 95000 and other objects around 10000 each. When we do the TTS migration from source to t...

To compare two same tables from different schema without primary key and not same number of columns

Wed, 12/18/2019 - 00:00
We have table 'CUSTOMER' in two different schema's. Both are not having any primary key and the column numbers in both table do not match(i.e schema1 table can have 97 column other schema table has 101).the column names are same which are present in ...

Merge Delete

Tue, 12/17/2019 - 00:00
How do I delete with a merge statement? I want to update MERGE_DELETE_TEST2 to match MERGE_DELETE_TEST1 (think ETL). I cannot get merge delete to remove the row that exists in MERGE_DELETE_TEST2 that does not exist in MERGE_DELETE_TEST1.