Not the entire library export, library size of 2 g export statement is as follows: ifsdump/* * * * * * * * @ 10.2.11.101/gretest directory=DPUMP_DIR dumpfile=gretest190121. DMP logfile=expdpparallel. Log schemas=ifsapp METRICS=Y parallel=5 mainly takes the log below:

W - 2.. exported "IFSAPP". "STATUTORY_FEE_DETAIL_TAB" 0 KB 0 rows in 0 seconds using direct_path
W - 2.. exported "IFSAPP". "STD_JOB_CATEGORY_TAB" 0 KB 0 rows in 0 seconds using direct_path
W - 3.. exported "IFSAPP". "SCHEDULER $_PROGRAM_ARG 8.187 KB" six rows in 2 seconds using external_table
W - 5 Processing object type SCHEMA_EXPORT/VIEW/COMMENT
W - 5 Completed 112277 COMMENT objects in 9676 seconds
W - 2 Completed 3106 SCHEMA_EXPORT/TABLE/TABLE_DATA objects in 70 seconds
W - 2 Master table "IFSDUMP". "SYS_EXPORT_SCHEMA_01" successfully the loaded/unloaded
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The Dump file set for IFSDUMP. SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/gretest dpdump/gretest190121 DMP
Job "IFSDUMP". "SYS_EXPORT_SCHEMA_01" successfully completed the at Mon Jan 21 12:24:35 2019 elapsed 0 02:54:24
==========================================================================


Consult on SCHEMA_EXPORT/VIEW/what is the COMMENT object, spent nearly three hours? How to analysis?

CodePudding user response:

The COMMENT is the note information table or column, there are so many remarks? To rule out these information first, see can speed up no,

CodePudding user response:

Plus exclude=COMMENT try note information filtering, necessary import slowly behind

CodePudding user response:

Thank you very much for the two, I tried, it is a note in this way, I don't understand is, less than two G database, note could lead to problems with export?