Flashback Schema (10g)
Jump to navigation
Jump to search
Technically there is no schema level flashback feature available. However, provided your recovery period does not include any data dictionary changes DDL) then you could actually use datapump to flashback export the schema and import it back in.
To achieve this you would use syntax like ...
expdp username/password directory=data_pump_dir dumpfile=data_pump_dir:dumpfile.dmp logfile=data_pump_dir:logfile.log schemas=SCHEMA flashback_time=\"to_timestamp('timestamp', 'yyyy-mm-dd hh24:mi')\"
The import process would use syntax like ...
impdp username/password directory=data_pump_dir dumpfile=DUMPFILE.DMP remap_schema=SCHEMA:SCHEMA
In this instance, I'm remapping the schema to another schema, so I can keep both in play for comparison purposes. You may choose to overwrite it instead.