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
清除完成；
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博客 ” ，链接：https://blog.itpub.net/29519108/viewspace-1386569/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
