9 Replies Latest reply on May 24, 2013 11:41 AM by Richard Harrison .

    Unable to use NETWORK_LINK parameter while EXPDP/ IMPDP

    user8907678
      Hi All,

      I am getting error while EXPDP/ IMPDP . When I am using NETWORK_LINK . I am getting error because of Logical DB. Please check this error.




      create public database link REFRESH_TABLE connect to sys identified by ****** using 'pmmprod';

      :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::


      expdp sys/**** directory=DMPDIR_CSTMSTEE NETWORK_LINK=REFRESH_TABLE dumpfile=CSTMSTEE.dmp logfile=exp_CSTMSTEE.log tables=PMM.CSTMSTEE content=data_only parallel=3

      Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 23 May, 2013 0:08:48

      Copyright (c) 2003, 2007, Oracle. All rights reserved.

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORA-39004: invalid state
      ORA-39091: unable to determine logical standby and streams status
      ORA-16103: Logical Standby apply must be stopped to allow this operation