Hi Gaurav,

You should try to import as user2. Then your tables will be imported into default tablespace of user2. User2 must have quotas on his default tablespace.

Imp userid=user2/password fromuser=user1 touser=user2 file=.... log=...

HTH

Volker Schoen
E-Mail: mailto:v.[Email address protected]
http://www.inplan.de




-----Ursprüngliche Nachricht-----
Von: Gaurav Tewari [mailto:oracledba-ezmlmshield-x51539707.[Email address protected]
Gesendet: Freitag, 29. April 2005 12:45
An: LazyDBA Discussion
Betreff: Import error-Urgent

Hi ,

I took export of user1 having his tables created with tablespace definition . As when i imported it using fromuser=user1 touser=user2 it gave error against those tables as the tablespace doesn't exist for user2 but it has enough of other tablespaces to accumaulate the data.
Can anyone help me and tell me how can table definition of exporeted user be modfied regarding the tablespace name so that they successfully imported to other user with other tablespace name.

Consider this as an urgent issue ,
Thanks & Regards,
Gaurav


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page