我有一个Oracle 11g,并且我想导出我所有的shcema对象,expdp as '/ as sysdba' directory=DIR dumpfile=DWH%U.dmp logfile=DWH.log filesize=40000m parallel=32 schemas=DWHEstimate in progress using BLOCKS method...Total estimation using BLO
我在跑步似乎不是企业版,所以我不能使用闪回功能ALTER DATABASE FLASHBACK ONERROR at line 1:
ORA-00439: feature not enabled: Flashback DatabaseSQL> SELECT flashback_on, log_mode FROM v$dat
在表更改后立即创建还原点时,还原点的FLASHBACK TABLE失败。下面的代码只在某些步骤之间有睡眠时才能工作。SQL> --Sleep required here to prevent error on flashback.SQL> FLASHBACK TABLE TEST_TABLE TO RESTORE POINT TEST_RESTORE_POINT;
FLASHBACK TABLE TEST_TABLE TO RESTORE