Home » RDBMS Server » Server Utilities » Import in a different tablespace (Oracle 10g)
Import in a different tablespace [message #346763] Tue, 09 September 2008 12:07 Go to next message
gokul_ifs
Messages: 41
Registered: March 2006
Location: india
Member
Hi,

I am trying to import a dump into a oracle 10g database.

While importing for some tables it throws an error saying that tablespace does not exist and the tables are not created.

The tablespace name in source database and destination database is different.

I would like to know how to specify the tablespace name with the import command , in which the database objects should be created.

Thanks in advance,
GOKUL
Re: Import in a different tablespace [message #346766 is a reply to message #346763] Tue, 09 September 2008 12:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
You have to either precreate the table or let them created in the user default tablespace.

Regards
Michel
Re: Import in a different tablespace [message #346767 is a reply to message #346763] Tue, 09 September 2008 12:12 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

You can not "specify" the tablespace name to use for import.

You must manually "pre-create" objects in the new/different tablespaces.
Previous Topic: Import using IMPDP
Next Topic: Import: Can we estimate the size needed for UNDO tablespace
Goto Forum:
  


Current Time: Wed Dec 07 04:58:59 CST 2016

Total time taken to generate the page: 0.12020 seconds