分区表数据泵导入太慢,达不到客户的迁移要求导出语句如下:(10G单节点)userid='/ as sysdba'directory=milk_dirdumpfile=mon_%U.dmplogfile=0828.logschemas=monparallel=8 导入语句(11G的rac):userid='/ as sysdba'directory=milk_dirdumpfile=mon_%U.dmplogfile=0828.logparallel=8CLUSTER=N 整个过程导出花费了3个小
结论: 10g to 10g:整个用户导出,无法正常导入JOB 10g to 11g:impdp时加SCHEMAS参数会导致无法正常导入JOB 11g to 11g:可以正常导入JOB 参见:http://blog.163.com/myy10146@126/blog/static/1135571862013813104626930/
实验: 源数据库:10.5.129.160 dwhtest 需要导入的数据库:10.5.129.130 dwhtest 在10.5.129.130上创建DBLINK SQL> create public database link DBL_DWHTEST connect to dwf identified by dwf using 'dwhtest160'; Database link created. SQL> select * from dual@DBL_DWHTEST; D - X 在