OraFAQ Forum: Server Utilities » Import in a different tablespace

Home » RDBMS Server » Server Utilities » Import in a different tablespace (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import in a different tablespace [message #346763]

Tue, 09 September 2008 12:07

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

Report message to a moderator

Re: Import in a different tablespace [message #346766 is a reply to message #346763]

Tue, 09 September 2008 12:12

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Import in a different tablespace [message #346767 is a reply to message #346763]

Tue, 09 September 2008 12:12

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	Import using IMPDP
Next Topic:	Import: Can we estimate the size needed for UNDO tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 10:33:01 CST 2024