Export sequence using expdp [message #503141] |
Wed, 13 April 2011 03:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
preet_kumar
Messages: 204 Registered: March 2007
|
Senior Member |
|
|
I would like to export specific tables(not entire schema) including metadata.
I am using a parameter file for expdp.
Tables=emp,dept
Does this also include all metadata or should i also add the below Include in the parfile ?
INCLUDE =Indexes,Sequences,Procedures,Views
|
|
|
|
Re: Export sequence using expdp [message #503143 is a reply to message #503142] |
Wed, 13 April 2011 04:04 ![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) |
preet_kumar
Messages: 204 Registered: March 2007
|
Senior Member |
|
|
In simple i am using expdp to export specific tables whose name is specified in a parfile.But while importing i don't get the sequences,so should i also specify the INCLUDE in the parfile while doing the export ?
|
|
|
Re: Export sequence using expdp [message #503146 is a reply to message #503143] |
Wed, 13 April 2011 04:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
If you export ONLY tables there is no reason to get sequences, if you want sequences you have to export a schema with include parameter to list the objects you want.
Regards
Michel
|
|
|