Home » Server Options » Streams & AQ » SUPPLEMENTAL LOG DATA
SUPPLEMENTAL LOG DATA [message #75727] Mon, 26 July 2004 03:40 Go to next message
MadLizard
Messages: 1
Registered: July 2004
Junior Member
Hi!

ALTER TABLE PRODUCT_RE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

ORA-00905: missing keyword
Re: SUPPLEMENTAL LOG DATA [message #75732 is a reply to message #75727] Thu, 12 August 2004 05:15 Go to previous message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
Hi,

Did you mean to say ALTER DATABASE or ALTER TABLE?

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Database altered.


SQL> ALTER TABLE scott.emp ADD SUPPLEMENTAL LOG GROUP emp_log_grp (empno);

Table altered.


Best regards.

Frank
Previous Topic: Oracle streams used in two different OS
Next Topic: dbms_rule_adm problem
Goto Forum:
  


Current Time: Thu Oct 23 09:10:41 CDT 2014

Total time taken to generate the page: 0.08769 seconds