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: Copying schema objects from one user's schema to anothers

Re: Copying schema objects from one user's schema to anothers

From: Javier Alonso <javiera_at_cat.es>
Date: 1997/02/07
Message-ID: <01bc14d8$1afd2360$338011ac@wja9ntcat>#1/1

I'm sorry, but there's no easy way.
1. Create table xxx as select * from asdd ... but this wont copy triggers, constraints, etc 2. exp owner=(xxx) ... imp fromuser=(xxx) touser=(yyy)

--

Good luck.
Javier Alonso
(javiera_at_cat.es)

Joseph Panico <jpanico_at_online.disney.com> escribió en artículo <32FA41BF.2E29_at_online.disney.com>...
Can someone tell me how to copy tables from one user's schema to another's?

Thanks for any tips.
--

	Joe Panico
	Disney Online
	jpanico_at_online.disney.com
Received on Fri Feb 07 1997 - 00:00:00 CST

Original text of this message

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