Home » RDBMS Server » Server Administration » How to enable the table level supplemental logging (10g )
How to enable the table level supplemental logging [message #399308] Tue, 21 April 2009 09:36 Go to next message
bravo13
Messages: 18
Registered: July 2008
Junior Member
Hi All,
How can we enable table level supplemental logging ?

Thanks in Advance.

Report message to a moderator

Re: How to enable the table level supplemental logging [message #399310 is a reply to message #399308] Tue, 21 April 2009 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+table+level+supplemental+logging

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to enable the table level supplemental logging [message #399330 is a reply to message #399308] Tue, 21 April 2009 11:36 Go to previous message
bravo13
Messages: 18
Registered: July 2008
Junior Member
ALTER TABLE <TableName> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

Report message to a moderator

Previous Topic: Error running ADDM report for particular snapshots
Next Topic: Drop user taking very long
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 00:45:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.