Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying schema objects from one user's schema to anothers
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.comReceived on Fri Feb 07 1997 - 00:00:00 CST