Hi all,
I am using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
i am facing issue while impdp on other server. it hangs at the bold line message below. it takes min. over 2-3 hours to continue. while importing i can not find any error message on alert log file or no any lock . then why it is taking too much time for importing ?
-***************-
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type DATABASE_EXPORT/STATISTICS/MARKER
here is my par file for impdp syntax :-
DIRECTORY=dir1
LOGFILE=abc_imp.LOG
DUMPFILE=abc.dmp
INCLUDE=SCHEMA:"IN('u1','u2','u3')"
include=role
content=METADATA_ONLY
TRANSFORM=SEGMENT_ATTRIBUTES:N
please let me know it any solution for this issue