Home » RDBMS Server » Server Utilities » Export sequence using expdp (Oracle 11g Linux)
Export sequence using expdp [message #503141] Wed, 13 April 2011 03:45 Go to next message
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 #503142 is a reply to message #503141] Wed, 13 April 2011 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 67545
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Title: "Export sequence using expdp"
Issue: "I would like to export specific tables(not entire schema) including metadata."

What is the relation between the 2?
The question is not clear.

Regards
Michel
Re: Export sequence using expdp [message #503143 is a reply to message #503142] Wed, 13 April 2011 04:04 Go to previous messageGo to next message
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
Michel Cadot
Messages: 67545
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
Previous Topic: SQLLDR
Next Topic: SQL Loader and Replace Function dont work.
Goto Forum:
  


Current Time: Sun Nov 29 04:11:36 CST 2020