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
Code: Select all
exp ... tables=owner.table:part_name query=\"where col1 \< 1000\"
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests