Re: Moving tables.

In article <338b3b76.10883473_at_news.ctv.es>, pjuanola_at_ctv.es says...
> On Thu, 22 May 1997 13:03:57 -0400, "W. H. Douglas"
> <wdouglas_at_cott.com> wrote:
>
> >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.
>
> Try EXporting the table and then IMPorting it into the new user.

If the table isn't that large you can also 'create table as select * from old_shema.table_name' -- 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---------------