Flashback : Guaranteed Restore Point

Oracle Flashback database and restore points enables us to rewind the database back in time to correct any problems caused by logical data corruption or user errors and it doesn't require any restoration of backup. There are 2 types of restoration points -- 1. Normal Restore Point --> assigns a restore point name to an … Continue reading Flashback : Guaranteed Restore Point

Advertisement

ORA-38500: Unsupported operation: Oracle XML DB not present

While trying to import using impdp got the below error Table "ANAND"."TEST" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "ANAND"."TEST":"Y2012_Q2_M06" failed to load/unload and is being skipped due to error: ORA-38500: Unsupported operation: … Continue reading ORA-38500: Unsupported operation: Oracle XML DB not present