Not sure what you mean "through user system"? System is a privileged user and you shouldn't be placing other users schemas into it. The export should be exp ... Owner=george ... And the import should be imp .... Fromuser=george touser=alm ....

-----Original Message-----
From: Shadab Mehboob [mailto:oracledba-ezmlmshield-x30357256.[Email address protected]
Sent: Wednesday, November 28, 2007 2:40 AM
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