oracle 11g2 rac数据库 expdp 导入 Oracle10g数据库(异平台hpunix-windows2008)

11g2rac  hpunix

$ sqlplus ris/ris@ris

SQL*Plus: Release 11.2.0.2.0 Production on Wed Jun 15 18:09:08 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options
$ expdp ris/ris@ris schemas=ris directory=DATA_PUMP_DIR dumpfile=6-15.dmp logfile=6-15.log version=10.2.0.3.0

Export: Release 11.2.0.2.0 - Production on Wed Jun 15 18:09:29 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
Starting "RIS"."SYS_EXPORT_SCHEMA_01":  ris/********@ris schemas=ris directory=DATA_PUMP_DIR dumpfile=6-15.dmp logfile=6-15.log version=10.2.0.3.0
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 951.2 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TYPE/TYPE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/JOB
. . exported "RIS"."ZLS_METERINFO"                       344.0 MB 1291603 rows
. . exported "RIS"."CUSTOMER"                            137.1 MB 1062245 rows
. . exported "RIS"."ZLS_CUSTINFO"                        146.4 MB 1291603 rows
. . exported "RIS"."METERINFO_MIRROR"                    29.79 KB       7 rows
. . exported "RIS"."E_FUNCTION"                          34.41 MB       4 rows
. . exported "RIS"."METERINFOEX"                         1.843 MB   30074 rows
. . exported "RIS"."CUSTREGDT"                           2.391 MB   17359 rows
. . exported "RIS"."CUSTCHANGEDT"                        1.465 MB   13442 rows
. . exported "RIS"."CUSTCHANGEDTHIS"                     1.443 MB   13300 rows
. . exported "RIS"."CUSTCHANGEHD"                        832.9 KB   10691 rows
. . exported "RIS"."RECORD_DETAIL"                       133.3 KB    2157 rows
. . exported "RIS"."CUSTREGHD"                           465.2 KB    5468 rows
. . exported "RIS"."RECORD_LIST"                         369.3 KB    2157 rows
. . exported "RIS"."SYNCQUEUE"                           188.3 KB    4433 rows
. . exported "RIS"."CALENDAR"                            66.57 KB    3652 rows
. . exported "RIS"."HB_HHL"                              268.9 KB   17999 rows
. . exported "RIS"."SYNCQUEUEHIS"                        335.3 KB    8648 rows
. . exported "RIS"."M4"                                  213.9 KB   18110 rows
. . exported "RIS"."A"                                   122.4 KB    1524 rows
. . exported "RIS"."B"                                   60.74 KB    1653 rows
. . exported "RIS"."BILLMAIN"                            13.09 KB      13 rows
. . exported "RIS"."ZLS_SYSMANAFRAME"                    42.96 KB     880 rows
. . exported "RIS"."CHARGE_TYPE"                         6.414 KB       4 rows
. . exported "RIS"."CUSTOMER_LB"                         5.648 KB       2 rows
. . exported "RIS"."CUSTOMER_STATUS"                     5.656 KB       3 rows
. . exported "RIS"."DERATELB"                            5.312 KB       2 rows
. . exported "RIS"."E_FUNCTION_HIS"                      7.648 KB       3 rows
. . exported "RIS"."FORM_FLAG"                           5.648 KB       2 rows
. . exported "RIS"."FORM_SOURCE"                         5.648 KB       2 rows
. . exported "RIS"."FUN_METHOD"                          10.09 KB     273 rows
. . exported "RIS"."JF_EMP"                              10.05 KB       6 rows
. . exported "RIS"."JF_FUNCMENU"                         14.39 KB      73 rows
. . exported "RIS"."METER_INFO_LOCAL"                    18.65 KB       6 rows
. . exported "RIS"."METER_LB"                            5.320 KB       3 rows
. . exported "RIS"."METER_STATUS"                        6.679 KB      26 rows
. . exported "RIS"."METER_TYPE"                          7.281 KB      14 rows
. . exported "RIS"."METHOD"                              7.007 KB      46 rows
. . exported "RIS"."OPERATOR"                            30.58 KB     207 rows
. . exported "RIS"."OPERATOR_BACKUP20110526"             33.94 KB     259 rows
. . exported "RIS"."OPERATOR_DATA_RANGE"                 20.42 KB     645 rows
. . exported "RIS"."OPERATOR_FUNCTION"                   8.265 KB     143 rows
. . exported "RIS"."OPERATOR_ROLE"                       11.28 KB     236 rows
. . exported "RIS"."OPERATOR_ROLE_BACKUP20110526"        16.76 KB     451 rows
. . exported "RIS"."OPERATOR_STATUS"                     5.640 KB       2 rows
. . exported "RIS"."OPERTATOR_METHOD"                    12.61 KB     244 rows
. . exported "RIS"."PAID_TRANS"                          5.328 KB       4 rows
. . exported "RIS"."PBCATEDT"                            7.976 KB      21 rows
. . exported "RIS"."PBCATFMT"                            6.570 KB      20 rows
. . exported "RIS"."PRICE"                               7.859 KB      18 rows
. . exported "RIS"."PRICE_CYCLE"                         6.023 KB       5 rows
. . exported "RIS"."PRICE_FRAME"                         9.351 KB      21 rows
. . exported "RIS"."PRICE_ITEM"                          5.640 KB       1 rows
. . exported "RIS"."PRICE_METHOD"                        5.328 KB       3 rows
. . exported "RIS"."PRICE_UNIT"                          6.070 KB       9 rows
. . exported "RIS"."RECORD_CHARGE_TYPE"                  5.703 KB       2 rows
. . exported "RIS"."RECORD_TRANS"                        5.343 KB       4 rows
. . exported "RIS"."ROLE"                                5.796 KB       7 rows
. . exported "RIS"."ROLE_FUNCTION"                       15.75 KB     491 rows
. . exported "RIS"."ROLE_METHOD"                         31.30 KB     907 rows
. . exported "RIS"."RPT_FIELDTYPE"                       5.445 KB       9 rows
. . exported "RIS"."RPT_FUNCTION_FILE"                   5.898 KB       9 rows
. . exported "RIS"."RPT_FUNCTION_QUERYFIELD"             9.554 KB      23 rows
. . exported "RIS"."RPT_ROLE"                            5.671 KB       2 rows
. . exported "RIS"."RPT_ROLE_RIGHTS"                     5.359 KB       4 rows
. . exported "RIS"."RPT_SHOWTYPE"                        5.406 KB       7 rows
. . exported "RIS"."RPT_USER"                            5.867 KB       5 rows
. . exported "RIS"."RPT_USER_RIGHTS"                     5.812 KB      30 rows
. . exported "RIS"."RPT_USER_ROLES"                      5.328 KB       3 rows
. . exported "RIS"."SYNCPARA"                            4.945 KB       1 rows
. . exported "RIS"."SYNCTYPE"                            6.406 KB       2 rows
. . exported "RIS"."SYSMANAFRAME"                           12 KB     129 rows
. . exported "RIS"."SYSMANAFRAMEEX"                      11.17 KB     121 rows
. . exported "RIS"."SYSMANAPARA"                         6.953 KB      25 rows
. . exported "RIS"."SYS_PARA"                            11.60 KB      90 rows
. . exported "RIS"."UPDATESTREET"                        7.078 KB      84 rows
. . exported "RIS"."COPY_CUSTINFO"                           0 KB       0 rows
. . exported "RIS"."COPY_METERINFO"                          0 KB       0 rows
. . exported "RIS"."CUSTOMER_PRICE"                          0 KB       0 rows
. . exported "RIS"."JF_EMP_ROLE"                             0 KB       0 rows
. . exported "RIS"."JF_ROLE"                                 0 KB       0 rows
. . exported "RIS"."PAIDADJUSTDDT"                           0 KB       0 rows
. . exported "RIS"."PAIDADJUSTDT"                            0 KB       0 rows
. . exported "RIS"."PAIDADJUSTHD"                            0 KB       0 rows
. . exported "RIS"."PAID_DETAIL"                             0 KB       0 rows
. . exported "RIS"."PAID_LIST"                               0 KB       0 rows
. . exported "RIS"."PAYMENT"                                 0 KB       0 rows
. . exported "RIS"."PBCATCOL"                                0 KB       0 rows
. . exported "RIS"."PBCATTBL"                                0 KB       0 rows
. . exported "RIS"."PBCATVLD"                                0 KB       0 rows
. . exported "RIS"."RECADJUSTDDT"                            0 KB       0 rows
. . exported "RIS"."RECADJUSTDT"                             0 KB       0 rows
. . exported "RIS"."RECADJUSTHD"                             0 KB       0 rows
. . exported "RIS"."RECTRANSDT"                              0 KB       0 rows
. . exported "RIS"."RECTRANSHD"                              0 KB       0 rows
. . exported "RIS"."RPT_FUNCTION"                            0 KB       0 rows
. . exported "RIS"."RPT_PARA"                                0 KB       0 rows
. . exported "RIS"."RUBBISH_DETAIL"                          0 KB       0 rows
Master table "RIS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for RIS.SYS_EXPORT_SCHEMA_01 is:
  /u01/app/oracle/product/11.2.0/db_1/rdbms/log/6-15.dmp
Job "RIS"."SYS_EXPORT_SCHEMA_01" successfully completed at 18:11:30

 

导入 window2008，oracle10.2.0.3.0

拷贝6-15.dmp到另一台win2008服务器e：/backup下

SQL> create directory impdp_dir as 'e:/backup ';

SQL> grant read,write on directory impdp_dir to ris；

cmd下

impdp ris/ris@ris schemas=ris directory=impdp_dir dumpfile=6-15.dmp.dmp logfile=6-15.dmp.log version=10.2.0.3.0