You can also do rows=yes(or no), indexes=no, constraints=no, then change
default tablespace for user to indexes, rows=, indexes=yes, constraints=

Or if you have room, put them all in with rows=no, and then rebuild the
empty indexes where you want, and move table where you want.

P.S. if source DB is enterprise edition, and destination is on another
database, consider investigating transportable tablespace options.

-----Original Message-----
From: seramu
[mailto:oracledba-ezmlmshield-x34810755.[Email address protected]
Sent: Friday, April 29, 2005 10:00 AM
To: LazyDBA Discussion
Subject: Re: Import error-Urgent

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





--------
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