為某一個table的所有列添加補充日誌的命令,table日誌命令

來源:互聯網
上載者:User

為某一個table的所有列添加補充日誌的命令,table日誌命令

GGSCI (gg321) 47> exit[oracle@gg321 ggs]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.4.0 - Production on Sun Apr 19 14:50:10 2015Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> 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)

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.