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

    [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...