Re: Moving tables.

From: Neil Greene <ngreene_at_laoc.SHL.com>
Date: 1997/05/27
Message-ID: <MPG.df4293c99e3179c989694@news.internetMCI.com>#1/1

[This followup was posted to comp.databases.oracle.server and a copy was sent to the cited author.]

In article <33847C7D.52E1_at_cott.com>, wdouglas_at_cott.com says...
> Is it possible to move a table to another schema without recreating the
> table ?
>
> I tried using rename and specifying the new schema name but that does
> not work.

No. You need to reorg the table. Be sure to check all objects dependant on this object like synonyms, procedures,etc.,etc. Or, use a tool like BMC Metamanage to do everything for you in a simple manner. --- neil

-- 
Neil Greene			Senior System Engineer / Oracle DBA	
MCI Systemhouse, Inc. 		<mailto:ngreene_at_laoc.SHL.com>

-----BEGIN PGP SIGNATURE-----
Version: 2.6.2

mQCNAzNWiBwAAAEEALmJ2Zho8BRcFc6vOHuUJp1TJ4+fZsmDgvi57DfDcnVCIcEv
e//qQ185dRN03821V7+MwfdKT51KOFcKRnHKFe8xGdDgMCB73ZFUn6X0acn3dVKn
K7kSTLpjcqlwGcEQb5MsH2oPz2ejUZ4+BghTN66nrZsEptkZOI+PVZH4HYSBAAUR
tCJOZWlsIEdyZWVuZSA8bmdyZWVuZUBsYW9jLlNITC5jb20+
=kEst
-----END PGP SIGNATURE---------------

Received on Tue May 27 1997 - 00:00:00 CDT