first, the parameters1.directory2.dumpfile3.logfile4.tables=table1,table2 ... 5.estimate_only=y6.exclude=statistics or statistics=none , and then for the user dbms_stats.gather_schema_stats (' SCHEMANAME ') or for the table Dbms_stats.gather_table_stats (' TABLENAME ') 7.remap_schema=old:new8.remap_tablespace=old:new9.cluster=n
Second, Progress view"Reference" 1.HTTP://BLOG.ITPUB.NET/9240380/VIEWSPACE-754878/2.HTTP://WWW.CNBLOGS.COM/EASTSEA/P/4614479.HTML1, view related views Dba_datapump_jobs dba_datapump_sessions2, Gv$datapump_jobs view job3, by Ps-ef | grep IMPDP View 4, view the job name in the imported log file, and then view the progress with the following command: $ IMPDP sys/passwd attach = sys. SYS_XXX_XX_68 can see the relevant import information and progress information.$ IMPDP SYS/PASSWD attach = sys. sys_xxx_xx_68Enter Import > prompt, can use kill_job or stop_job end or stop job, stop job can continue, kill not.
Data Pump IMPDP EXPDP