OraFAQ Forum: Server Utilities » import data in one tablespace

Home » RDBMS Server » Server Utilities » import data in one tablespace (oracle 11g, 11.2.0.3.0, Solaris 10)

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

import data in one tablespace [message #600399]

Wed, 06 November 2013 01:26

zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN

Member

hi,

I have taken an export using expdp of schema, data of the schema spread across different tablespaces , now i want to import the data to only one tablespace, how can i achive this ?

Thanks
Zeeshan

Report message to a moderator

Re: import data in one tablespace [message #600403 is a reply to message #600399]

Wed, 06 November 2013 01:39

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Investigate use of IMPDP's REMAP_TABLESPACE parameter.

Report message to a moderator

Previous Topic:	Intermediate COMMITS when using the sqlldr or imp utilities
Next Topic:	error while impdb

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:36:03 CST 2025