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!

exp using query parameter

ivwviFeb 17 2009 — edited Jul 10 2012

Hi All,
I need to export a table with query clause ="where rownum<100"
Its working fine,but extracting all columns.
But I need only selective columns.

Is it possible to exporting follwing records

select some_columns from table where rownum<100

how to do it with exp util?

DB version 10.2.0.4
OS AIX

Thanks,

This post has been answered by 678145 on Feb 17 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2012

Added on Feb 17 2009

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

12 comments

21,070 views