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: 4579
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 Mar 28 16:28:19 CDT 2024