I am trying to import a few user schemas from a 11g DB to a 12c PDB, through network_link. The source DB resides on a RHEL box, while the target DB on an Oracle Linux. The job hangs at the beginning. However, using the same DB link and user (system), I am able to SELECT data of the source-DB from the target DB.
Here is the import log so far:
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
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/********@mydbname parfile=full.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
v$session info:
On the target DB, the import user's session has WAITING_CLASS=network, EVENT="SQL*Net message from dblink".
On the source DB, the corresponding user session has
either WAITING_CLASS=Concurrency and EVENT = 'latch: shared pool"
or WAITING_CLASS = user I/O and EVENT= data file sequential read
Any tips are appreciated.
Thanks.
John.