Gaurav,

Unfortunately, import looks for the same tablespace name in the
destination account. So, it's better to pre-create the tables and import
with ignore=y option.

#1 Use "INDEXFILE" option in the import utility to capture the DDLs
#2 Pre-create the tables
#3 Import with ignore=y

-Aliyar Sahib




"Gaurav Tewari "
<oracledba-ezmlms
hield-x51539707.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
04/29/2005 06:45
AM Subject
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