为某一个table的所有列添加补充日志的命令

最新推荐文章于 2023-09-07 17:32:48 发布

msdnchina

最新推荐文章于 2023-09-07 17:32:48 发布

阅读量1.5k

点赞数

分类专栏： Oracle DB Oracle GoldenGate

本文链接：https://blog.csdn.net/msdnchina/article/details/45046261

版权

Oracle DB 同时被 2 个专栏收录

773 篇文章 3 订阅

订阅专栏

Oracle GoldenGate

101 篇文章 0 订阅

订阅专栏

GGSCI (gg321) 47> exit
[oracle@gg321 ggs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Apr 19 14:50:10 2015

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.



Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> SQL> SQL>
SQL>
SQL>
SQL>
SQL>
SQL> ALTER TABLE USERA.TABA   ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

Table altered.

SQL> exit

参考文章：

Add Trandata / ORA-00054: resource busy and acquire with NOWAIT (Doc ID 1554364.1)