1 import with indexfile=ddl.sql
2 edit the ddl.sql file changing all TBS1 to TBS2. Comment out all the create index statements and uncomment the create table statements.
3 sqlplus / @ddl.sql ( to pre-create the tables only)
4 imp rows=y indexes=n ignore=y
5 edit the ddl.sql script and use it to create your indexes.
-----Original Message-----
From: kidambi [mailto:oracledba-ezmlmshield-x98359643.[Email address protected]
Sent: Sunday, August 05, 2007 10:49 PM
To: LazyDBA Discussion
Subject: Importing data in an Oracle 9i Database
Hi all,
A case of importing data to a Oracle 9i database:
The source schema's default tablespace is TBS1 ( all the objects have
TBS1as their tablespace). I have specified the target schema's default
tablespace as TBS2 ( all the objects should have TBS2 as their tablespace). In this scenario, I face 2 issues.
1) As TBS1 Tablesapace is available in target database also, all the objects get imported into this tablespace eventhough I have specified TBS2 as the target schema's default tablespace.
2) TBS1 Tablesapace is not available in target database. Receive an error mentioning that TBS1 tablespace does not exist eventhough I have specified TBS2 as the target schema's default tablespace.
Please suggest a way by which I can overcome this issue and get the source schema's objects imported into TBS2 tablespace in the target side.
Thanks.
Kind regards,
Raj
"Save Paper - Do you really need to print this e-mail?"
This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.
Visit us at http://www.polaris.co.in
---------------------------------------------------------------------
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