Re: Help! How to use SQLPLus COPY command to copy schema

A copy of this was sent to Fredrik Bonde <fredrik_at_nospam.iconmedialab.co.uk> (if that email address didn't require changing) On Fri, 18 Jun 1999 16:06:14 +0100, you wrote:

>Hi there,
>I need to copy a whole schema from on db to another. From what I know it
>is possible to use the COPY command to do this. I have however not found
>any information on how to do so... Can anyone give me a clue?
>
>
>regards
>
>Fredrik

I think what you are looking for is exp and imp.

imp fromuser=user1 touser=user2

copy only copies a single table.

-- 
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Fine Grained Access Control", added June 8'th
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation