Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming master table of a snapshot
Nice how they do that to you, eh?
dbms_repcat.switch_snapshot_master
Mike Glasser wrote in message <37F27363.C9923A44_at_accmail.umd.edu>...
>I am attempting to rename a table that is replicated to another site. When
I
>attempt to do this, I get Oracle error 26563.
>
>$ oerr ora 26563
>26563, 00000, "renaming this table is not allowed"
>// *Cause: Attempt to rename a replicated table, an updatable snapshot
table
>// or the master table of a snapshot for which a snapshot log has
been
>// created.
>// *Action: If desired, unregister the replicated table with
>// dbms_repcat.drop_master_repobject, or use the recommended
>// procedure to rename the master table of a snapshot.
>$
>
>Does anyone know what is the "recommended procedure to rename the master
table
>of a snapshot."? TIA for any help.
>
>--
>Mike Glasser
>
>Administrative Computer Center
>University of Maryland
>mglasser_at_accmail.umd.edu
>
>
Received on Wed Sep 29 1999 - 16:07:53 CDT
![]() |
![]() |