drop apply INSTANTIATION for one table
drop apply INSTANTIATION for one table
http://www.itpub.net/viewthread.php?tid=1114837
begin
dbms_apply_adm.set_table_instantiation_scn (
source_object_name => 'szhao.onewaydept',
source_database_name => 'strm10.world',
instantiation_scn => NULL
);
end;
/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/756652/viewspace-541350/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- drop table和truncate table的區別
- flashback drop/query/table/database/archiveDatabaseHive
- How To Efficiently Drop A Table With Many Extents
- oracle 誤刪表 drop tableOracle
- ssis multiple table to one file
- the procedure:delete the data of one tabledelete
- audit drop table為什麼不行
- Drop table cascade constraintsAI
- [doc]How To Efficiently Drop A Table With Many Extents
- How to monitor data transaction on one table
- Oracle10g 回收站及徹底刪除table : drop table xx purge 以及drop flashOracle
- 深入解析 oracle drop table內部原理Oracle
- DROP TABLE ** CASCADE CONSTRAINTS PURGEAI
- MySQL資料災難挽救之drop tableMySql
- Drop Table Fails With ORA-600 [15264]AI
- MySQL 5.6 drop database時,table metadata lock等待MySqlDatabase
- Truncate table 詳解及與delete,drop 的區別delete
- Truncate table詳解及與delete,drop的區別delete
- 資料庫審計(create/alter/drop table、user、tablespace)資料庫
- v$lock之alter table drop column與alter table set unused column區別系列五
- MySQL DROP TABLE刪除表報錯'ERROR 1051 (42S02): Unknown table'MySqlError
- oracle drop table purge無備份bbed恢復(1/3)Oracle
- oracle drop table purge無備份bbed恢復(2/3)Oracle
- oracle drop table purge無備份bbed恢復(3/3)Oracle
- 外來鍵約束drop table cascade constraintsAI
- 主子表drop table constraints cascade的測試AI
- 執行drop table base purge出現ora_00604
- Drop Table Fails With ORA-600 [15264] [ID 338953.1]AI
- Oracle10g 回收站及徹底刪除table : drop table xx purge 以及flashbackOracle
- 閃回之 回收站、Flashback Drop (table、index、trigger等)Index
- 直接登入資料庫使用drop table tablename;會是什麼情況?資料庫
- [20181203]drop table後如何獲得表結構.txt
- Truncate table時不管使用drop storage或reuse storage都會講HWM重新設定
- Backup And Recovery User's Guide-使用閃回刪除來回退DROP TABLE操作GUIIDE
- drop asm disk、撤銷drop asm diskASM
- tomcat one connection one thread one request one threadTomcatthread
- Drop DatabaseDatabase
- oracle 11g之alter table drop unused columns checkpoint刪除表不可用列系列二Oracle