OraFAQ Forum: Streams & AQ » SUPPLEMENTAL LOG DATA

Home » Server Options » Streams & AQ » SUPPLEMENTAL LOG DATA

Mon, 26 July 2004 03:40

MadLizard
Messages: 1
Registered: July 2004

Junior Member

Hi!

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

ORA-00905: missing keyword

Thu, 12 August 2004 05:15

Frank Naude
Messages: 4381
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: Tue Jun 18 18:40:26 CDT 2013

Total time taken to generate the page: 0.08504 seconds