Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: reorganize snapshot log
On Mar 14, 10:43 am, "Valentin Minzatu" <valentinminz..._at_yahoo.com>
wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
I think I know why it didn't work for you. Do not specify the "new"
tablespace name. Just do:
alter table vcrs.MLOG$_BOUNCES move;
Received on Wed Mar 14 2007 - 09:44:53 CDT
![]() |
![]() |