Re: copy one users table and data to another user

aldrinv_at_aeg.com.hk (aldrinv) wrote in message news:<93fd5203.0203280119.133b5c20_at_posting.google.com>...
> we just recently upgrade to oracle 8i databse from Oracle 7.3. Now we
> want to copy a one user tables into another user. How can we do so.
> Please someone help me.

There are several ways to copy data from one user to another:

exp tables for user A then
imp fromuser=A touser=B .....

Or

(see SQL manual under create table)
create table B.emp
 as select * from A.emp ....

HTH -- Mark D Powell -- Received on Thu Mar 28 2002 - 14:58:51 CET