如果我们误操作,添加了一个命名错误复制进程,这个时候如果我们想删掉,
重新新建复制进程,则删除步骤如下:
[:oracle]ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.26 Build 001
AIX 5L, ppc, 64bit (optimized), Oracle 11 on Mar 2 2011 21:38:45
Version 11.1.1.0.26 Build 001
AIX 5L, ppc, 64bit (optimized), Oracle 11 on Mar 2 2011 21:38:45
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI () 1> add replicat rtest, exttrail /software/ggs/dirrpt/te , checkpointtable ggt.ckptfpfxdm
REPLICAT added.
REPLICAT added.
GGSCI () 2> delete replicat rtest
ERROR: Could not delete DB checkpoint for REPLICAT RTEST (Database login required to delete database checkpoint).
GGSCI () 3> dblogin userid ggt,password ggt
Successfully logged into database.
GGSCI () 4> delete replicat rtest
Deleted REPLICAT RTEST.
Deleted REPLICAT RTEST.
注意一定要登录到dblogin到目标数据库,否则提示要删除checkpoint table
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-706209/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-706209/