GOLDENGATE 清除DDL環境

studywell發表於2014-12-31
This procedure removes all of the Oracle GoldenGate DDL objects from the DDL schema on a source system.

1、Log in to SQL*Plus as a user that has  SYSDBA  privileges。
2、Disconnect all sessions that ever issued DDL, including those of Oracle GoldenGate processes, SQL*Plus, business applications, and any
other software that uses Oracle. Otherwise the database might generate an ORA-04021 error.
3、@ddl_disable.sql
4、@ddl_remove.sql
5、@marker_remove.sql

清除完成;




來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29519108/viewspace-1386569/,如需轉載,請註明出處,否則將追究法律責任。

相關文章