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
- Created a TNS entry for the source database in the target server.
- Created a public database link for the source schema using the tns name.
- 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>