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
Thanks and Regards