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