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

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1997/02/07
Message-ID: <32fa8fac.3689615@nntp.mediasoft.net>#1/1

On Thu, 06 Feb 1997 15:40:31 -0500, Joseph Panico <jpanico_at_online.disney.com> wrote:
>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

exp owner=user1

imp fromuser=user1 touser=user2 commit=y

should do it, would grab everything in the one schema (user1) and copy it into the other (user2).

see the server utilities guide for more info on exp (export) and imp (import)...

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Fri Feb 07 1997 - 00:00:00 CST