Re: reorganize snapshot log

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Tue, 13 Mar 2007 15:48:33 -0400
Message-ID: <gnvdv21hmmn1s02tkm7a9oirjqef0md2uo@4ax.com>

>
>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 Received on Tue Mar 13 2007 - 14:48:33 CDT