6 Replies Latest reply: Aug 21, 2014 3:19 PM by Srini Chavali-Oracle RSS

    expdp , export only 1000 from each table

    Jr.raj

      Hi oracle gurus,

       

      My oracle Version is 12c,

      i have 1000 tables in mu database, database size is 700GB,

      for testing purpose, i need sample data of 1000rows data from each table.

      so how can i export 1000 rows from each table using expdp

       

      Thanks in advance

       

      Regards

      raj