GOLDENGATE 清除DDL環境
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部落格 ” ,連結:http://blog.itpub.net/29519108/viewspace-1386569/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle GoldenGate環境搭建OracleGo
- Oracle高可用環境之DDL操作Oracle
- goldengate 單向DDLGo
- 【GoldenGate】Oracle GoldenGate(三) DDL同步配置GoOracle
- 配置GoldenGate啟動DDL支援同步DDL操作Go
- goldengate ddl 配置說明Go
- goldengate配置DDL複製Go
- Oracle9i流環境清除(三)Oracle
- Oracle9i流環境清除(二)Oracle
- Oracle9i流環境清除(一)Oracle
- GoldenGate簡單複製環境的搭建Go
- GoldenGate學習筆記(10)_RAC環境Go筆記
- (轉)Oracle rac環境下清除asm例項OracleASM
- 在RAC環境下安裝實施GoldenGateGo
- GoldenGate在異構環境下的複製Go
- oracle goldengate 配置DML&DDL實驗OracleGo
- GoldenGate配置(三)之DDL複製配置Go
- 搭建oracle 11.2.0.4環境下的goldengate複製OracleGo
- goldengate 生產環境下實施注意事項Go
- 配置支援DML和DDL操作同步的GoldenGateGo
- goldengate 支援ddl的資料庫型別Go資料庫型別
- goldengate ddl_setup執行失敗處理Go
- GoldenGate單向複製配置(支援DDL複製)Go
- DB2 DDL操作引起的GoldenGate錯誤DB2Go
- 使用PURGEOLDEXTRACTS設定goldengate自動清除trail fileGoAI
- Goldengate複製程式錯誤Fatal error executing DDLGoError
- ORACLE GOLDENGATE抽取程式在AIX裸裝置環境中無響應OracleGoAI
- goldengate 12.3 實現mysql資料及DDL實時同步GoMySql
- Oracle GoldenGate10g→11g單向DDL部署OracleGo
- 為已經執行的GoldenGate開啟DDL選項Go
- Oracle goldengate 11g (二)【DML and DDL單向複製】OracleGo
- 搭建一個Oracle到Oracle的GoldenGate單向複製測試環境OracleGo
- 配置開發環境、生成環境、測試環境開發環境
- oracle goldengate ddl 操作導致複製程式abended處理案例OracleGo
- REMOVE_STREAMS_CONFIGURATION過程清除流環境報錯ORA-24042REM
- windows環境下Django環境搭建WindowsDjango
- 環境變數{Linux環境(也稱為Shell環境)}(轉)變數Linux
- Windows環境下的Nginx環境搭建WindowsNginx