How to Query option in exp

[anthony]

Hi All,

I need to export one particular partitioned table partition with only first 1000 rows,We do not have primary key to export like below.

exp ..... query=\"where col1 \< 1000\"

By using this query i a m able to select rows.
select * from TMS2ADM.AC_BALANCES partition (SYS_P124) where rownum <=1000;

Could you please help me how to export first 1000 rows by using exp...

Tanks and Regards
Anthony.

[Tim...]

Hi.

Try:

Code: Select all

exp ... tables=owner.table:part_name  query=\"where col1 \< 1000\"

Cheers

Tim...