OraFAQ Forum: Server Utilities » Import a single tablespace from a full export dump file

Home » RDBMS Server » Server Utilities » Import a single tablespace from a full export dump file (Oracle 10g,11g , Linux 6)

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

Import a single tablespace from a full export dump file [message #617433]

Mon, 30 June 2014 02:56

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Hi ,

Is it possible to import a single tablespace from a full export dump file ? if so how to do that ?

Regards,
Suhas

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617436 is a reply to message #617433]

Mon, 30 June 2014 03:20

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

Senior Member
Account Moderator

Which kind of export? old or Data Pump?

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617438 is a reply to message #617436]

Mon, 30 June 2014 03:49

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

data pump

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617440 is a reply to message #617438]

Mon, 30 June 2014 04:18

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

Senior Member
Account Moderator

Try to use the following option:
INCLUDE=TABLESPACE:<your ts name>

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617442 is a reply to message #617440]

Mon, 30 June 2014 04:20

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Thanks Michel Smile

Is it not possible to import from normal export (exp )and import (imp) ?

[Updated on: Mon, 30 June 2014 04:23]

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617445 is a reply to message #617442]

Mon, 30 June 2014 04:29

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

Senior Member
Account Moderator

No, it is not... and I'm not it will work with Data Pump as I didn't try it, it was just an idea.
Tell us the result.

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617447 is a reply to message #617445]

Mon, 30 June 2014 04:45

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Michel,

I checked in oracle documentation and found there is no keyword called 'INCLUDE=TABLESPACE' in data pump and in normal export and import method .

[Updated on: Mon, 30 June 2014 05:15]

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617452 is a reply to message #617447]

Mon, 30 June 2014 05:09

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Go here: http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_import.htm#i1007653
search for tablespace.

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617454 is a reply to message #617452]

Mon, 30 June 2014 05:29

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Thanks Cookie,

Yes,there is a keyword named 'TABLESPACES' in data pump which imports tablespace from export dump file.

> impdp hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp TABLESPACES=tbs_1,tbs_2,tbs_3,tbs_4

This example imports all tables that have data in tablespaces tbs_1, tbs_2, tbs_3, and tbs_4.

But not sure in original export import method.

[Updated on: Mon, 30 June 2014 05:35]

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617465 is a reply to message #617454]

Mon, 30 June 2014 06:54

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

I don't believe it's possible with imp/exp.

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617466 is a reply to message #617465]

Mon, 30 June 2014 07:01

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Can you provide the link for original export and import ?

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617475 is a reply to message #617466]

Mon, 30 June 2014 07:30

cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester

Senior Member

Go to http://docs.oracle.com/
Find the correct version for your DB.
Find the master book list.
Find the utilities book.

Or just type export into the search box on the main page of the documentation.

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617508 is a reply to message #617475]

Tue, 01 July 2014 01:27

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Cookiemaster,

Yes,there is a Tablespace parameter available in original import as well .

Thanks

[Updated on: Tue, 01 July 2014 01:28]

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617511 is a reply to message #617508]

Tue, 01 July 2014 02:40

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

Senior Member
Account Moderator

But it is only for transportable tablespaces.

Report message to a moderator

Re: Import a single tablespace from a full export dump file [message #617514 is a reply to message #617511]

Tue, 01 July 2014 03:45

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Yes Michel,you are correct.
Tablespace parameter available in original import is only for transportable tablespaces.
Therefore it is not possible to import single tablespace from export dump file using original export and import method. Razz

Please correct me if i am wrong.

[Updated on: Wed, 02 July 2014 00:42]

Report message to a moderator

Previous Topic:	sql loader data isse
Next Topic:	username/password in exp/imp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 13:12:09 CST 2025