Skip to main content

CoPY command error and rowcount

  • June 10, 2015
  • 1 reply
  • 7 views
Sreedhar1

How to handle errors for copy command (not the rejects/exceptions files) and is there any variable/table where the total rows loaded using copy command are stored. I checked load_streams table but the table was empty

    1 reply

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • June 10, 2015

    Hi Sreedhar,

     

          Once you load the data using copy command, execute the following query to know the count of rows loaded successfully

     

    select get_num_accepted_rows();

     

     

    -Regards,

     Sruthi

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement