0

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 last 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 if any solution for this issue ?

Improve this question

1 Answer 1

Reset to default
1

Known bug, still under investigation.

Workaround is to use exclude=statistics.

Improve this answer
6
  • DIRECTORY=dir1 LOGFILE=abc_imp.LOG DUMPFILE=abc.dmp INCLUDE=SCHEMA:"IN('u1','u2','u3')" include=role content=METADATA_ONLY TRANSFORM=SEGMENT_ATTRIBUTES:N exclude=statistics
    – Ray
    Commented Nov 20, 2018 at 7:01
  • Facing Error :- UDI-00011: parameter include is incompatible with parameter exclude
    – Ray
    Commented Nov 20, 2018 at 9:08
  • @vvs EXCLUDE and INCLUDE parameters are mutually exclusive. You can use exclude=statistics on export as well. Or you can create the roles, then run 3 seperate schema mode imports without the include parameter, which allows you to use exclude=statistics on import.
    – Balazs Papp
    Commented Nov 20, 2018 at 9:14
  • @ Balazs Papp thanks for the replay but in real time i have a number of schemas so it is not possible to do every time & also they all Schemas have dependency on each other
    – Ray
    Commented Nov 20, 2018 at 9:39
  • @vvs Then you can use the schemas=u1,u2,u3 parameter for performing schema mode import.
    – Balazs Papp
    Commented Nov 20, 2018 at 9:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.