Home » RDBMS Server » Server Utilities » export/import tablespace
export/import tablespace [message #232805] Mon, 23 April 2007 05:59 Go to next message
sanjitpandey
Messages: 16
Registered: April 2007
Junior Member
Hi,

I am trying to export/import a tablespace in oracle 10g.
i am using following script:

expdp user/pwd DIRECTORY=santest DUMPFILE=SAN_TEST.dmp LOGFILE=SAN_TEST.log TABLESPACES=SAN_TEST;

but when i try to import SAN_TEST.dmp using following script:

impdp user/pwd DIRECTORY=santest DUMPFILE=SAN_TEST.dmp;

I need to first create tablespace for new destination.

can any body help me how to export/import so that whole tablespace information along with its contents get exported/imported

thanks
Sanjit

[Updated on: Mon, 23 April 2007 06:00]

Report message to a moderator

Re: export/import tablespace [message #232856 is a reply to message #232805] Mon, 23 April 2007 11:58 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
I need to first create tablespace for new destination.
If you want to transfer one tablespace from source database to target database.
then better you can use TRANSPORT_TABLESPACE option if your able to make your database READ ONLY mode.
just for example
http://dbataj.blogspot.com/2007/01/transport-tablespace_04.html

regards
Taj
Previous Topic: Oracle Import
Next Topic: import only data
Goto Forum:
  


Current Time: Fri Dec 09 07:42:31 CST 2016

Total time taken to generate the page: 0.04772 seconds