| Export sequence using expdp [message #503141] |
Wed, 13 April 2011 03:45  |
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  |
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 |
 |
Michel Cadot
Messages: 68509
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
