Home » RDBMS Server » Server Utilities » Import a single tablespace from a full export dump file (Oracle 10g,11g , Linux 6)
Import a single tablespace from a full export dump file [message #617433] Mon, 30 June 2014 02:56 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58496
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Which kind of export? old or Data Pump?

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 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
data pump
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58496
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58496
Registered: March 2007
Location: Nanterre, France, http://...
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.

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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 10845
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.
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 10845
Registered: September 2008
Location: Rainy Manchester
Senior Member
I don't believe it's possible with imp/exp.
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 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Can you provide the link for original export and import ?
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 Go to previous messageGo to next message
cookiemonster
Messages: 10845
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.
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58496
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

But it is only for transportable tablespaces.

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 Go to previous message
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:
  


Current Time: Wed Jul 23 05:45:59 CDT 2014

Total time taken to generate the page: 0.09308 seconds