Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import over database link

2913770Oct 9 2015 — edited Oct 13 2015

I am trying to import tables from one database to another via a database link. But facing a weird error. Please help.

Operating System :  Oracle Linux Server release 6.4

Source Database   : Oracle 12.1.0.2

Target Database   : Oracle 12.1.0.2


Steps

  1. Created a TNS entry for the source database in the target server.
  2. Created a public database link for the source schema using the tns name.
  3. Created a database directory in target database and granted permission to the target user.

Executed the below command

     impdp username/password directory=dirname tables=schema.tablename network_link=linkname

Getting the below output

Import: Release 12.1.0.2.0 - Production on Fri Oct 9 14:51:32 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

ORA-39004: invalid state

ORA-39091: unable to determine logical standby and streams status

ORA-06550: line 1, column 47:

PLS-00103: Encountered the symbol "IN" when expecting one of the following:

   <an identifier> <a double-quoted delimited-identifier>


This post has been answered by PKR on Oct 11 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2015
Added on Oct 9 2015
10 comments
2,209 views