Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Renaming master table of a snapshot

Re: Renaming master table of a snapshot

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Wed, 29 Sep 1999 17:07:53 -0400
Message-ID: <37f27ff0@defiant.btitelecom.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US