Presume you are using IMP rather than data pump IMP(?)...using dpIMP
you can remap the schema from one user to another (REMAP_SCHEMA)...the
TOUSER parameter is analogous to the REMAP_SCHEMA in IMP...

E.g. TOUSER=ALM

You'll also need the associated privileges to run the IMP - for the user
to IMP; and for the directory you're importing from.

Out of interest why are you importing tables from SYSTEM schema to one
DB and then importing them again to another DB? If you are using 10g
you could try dpIMP using network mode - NETWORK_LINK - No dumpfile(s)
required.

Cheers
Andrew

-----Original Message-----
From: Shadab Mehboob
[mailto:oracledba-ezmlmshield-x30357256.[Email address protected]
Sent: Wednesday, November 28, 2007 11:40 PM
To: LazyDBA Discussion
Subject: import tables from one user to another

Dear Masters
I imported all tables from one database through user "SYSTEM" and then i
imported these tables into another database into a user "ALM" but these
tables are still owned by user SYSTEM in the new database , how do i
make these tables owned bu ALM in the new database Kindly help Regards
Shadab


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page