Re: 9i streams setup

On Wed, 30 Nov 2005 15:42:23 -0800, epipko wrote:

>
> alter table ub_objects.test add supplemental log data (all) columns;
>

9i syntax ...

ALTER TABLE table ADD SUPPLEMENTAL LOG GROUP log_group (column_list)ALWAYS;

or

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS; I think you want the first variant.

Note the Streams docco has a single table example ...

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***