7 Replies Latest reply: Oct 9, 2013 4:48 PM by Turloch O'Tierney-Oracle RSS

    [4.0 EA2] Datapump export job: "SCN must be positive integer"

    Stew Ashton

      I want to recommend SQL Developer as the user interface for Data Pump jobs (since we do not have OEM).

       

      On the export job interface, the choice "export read-consistent view of data" fails if the SCN is >= 2147483648. I get the error "SCN must be positive integer".

       

      While I'm at it, the "By Date" option fails too, since the date displayed uses local settings and the PL/SQL code generated uses database settings!

       

      This is a show stopper for recommending the tool, since I do want exports to be read consistent...