1. 首页 > ITPUX技术网 > 正文

Oracle goldengate删除复制进程步骤

Oracle goldengate 删除复制进程步骤

如果我们误操作,添加了一个命名错误复制进程,这个时候如果我们想删掉,

重新新建复制进程,则删除步骤如下:

[: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
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.

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.

注意一定要登录到dblogin到目标数据库,否则提示要删除checkpoint table

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

联系我们

在线咨询:点击这里给我发消息

微信号:itpux-com

工作日:9:30-18:30,节假日休息