On Mar 13, 3:48 pm, NetComrade <netcomradeNS..._at_bookexchange.net>
wrote:
> >Have you tried ALTER TABLE MLOG$_MEMBER_SUMMARY MOVE? I think it
> >should work - I do not have a test bed to try it out.
>
> I haven't tried it, b/c I believed it was not supported on snapshot
> logs (prob b/c snapshot log already has triggers populating it, and
> any move operation might create a temporary table populating it with
> yet another set of triggers). The orafaq link above states that you
> can't do 'table redefinition' on snapshot logs among other things.
>
> Just tried it with another log on a table which hasn't been replicated
> in over a year (nor populated), doesn't work:
>
> system_at_VCRS> alter table vcrs.MLOG$_BOUNCES move payproductsdat;
> alter table vcrs.MLOG$_BOUNCES move payproductsdat
> *
> ERROR at line 1:
> ORA-14133: ALTER TABLE MOVE cannot be combined with other operations
>
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
> remove NSPAM to email
I am not sure what is the definition for your log (and what version of
Oracle you are using), but I have just tested with 10R1 and it worked.
Received on Wed Mar 14 2007 - 09:43:12 CDT
