|
|
|
|
|
|
|
|
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/15c82c7d9fc8aa37529ca79b866d6993?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|
|