Home » RDBMS Server » Server Utilities » import data in one tablespace (oracle 11g, 11.2.0.3.0, Solaris 10)
import data in one tablespace [message #600399] Wed, 06 November 2013 01:26 Go to next message
zeeshan047
Messages: 63
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
Re: import data in one tablespace [message #600403 is a reply to message #600399] Wed, 06 November 2013 01:39 Go to previous message
Littlefoot
Messages: 19889
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Investigate use of IMPDP's REMAP_TABLESPACE parameter.
Previous Topic: Intermediate COMMITS when using the sqlldr or imp utilities
Next Topic: error while impdb
Goto Forum:
  


Current Time: Fri Dec 19 16:54:37 CST 2014

Total time taken to generate the page: 0.06025 seconds