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

Oracle LazyDBA home page