Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a way to take export dump with only selected objects

UllhasMar 20 2009 — edited Mar 31 2009

Hi,

I want to take a partial export dump containing only few objects of a particular schema in Oracle 10g DB.
I am trying to use "exp" utility for this.

The parfile used for this is as follows:

FILE=CSG_Objects.dmp
FULL=n
ROWS=y
COMPRESS=y
INDEXES=y
TRIGGERS=y
CONSTRAINTS=y
LOG=export_CSG_Objects.log
TABLES=table1,table2,table3...

With this I can only export tables but not other objects like views, procedures, sequences etc.
If I try to use other object name in TABLES list, I get errors.
Is there any way I could export other "selected" objects also?

Thanks & Regards,
Ullhas

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2009

Added on Mar 20 2009

#database-key-features, #export-import-sql-loader-external-tables

4 comments

1,829 views