摘要：
dropdirectorymydata;/u01/app/oracle/oradata/xe/u01/app/oracle/oradata/xe/tmpdatacreatedirectorymydataas'/u01/app/oracle/oradata/xe/tmpdata';从用户osbpm中，导出dmp文件$ORACLE_HOME/bin/expdposbpm/xxxx@127.0.0.1/
drop directory mydata; /u01/app/oracle/oradata/xe /u01/app/oracle/oradata/xe/tmpdata create directory mydata as '/u01/app/oracle/oradata/xe/tmpdata'; 从用户osbpm中，导出dmp文件 $ORACLE_HOME/bin/expdp osbpm/xxxx@127.0.0.1/xe directory=mydata schemas=osbpm dumpfile=osbpm210925.dmp logfile=expdp.log; 将dmp文件，从osbpm用户导入到osbpm1用户 grant read,writeon directory mydata to osbpm1 $ORACLE_HOME/bin/impdp osbpm1/xxxx@127.0.0.1/xe directory=mydata dumpfile=osbpm210925.dmp remap_schema=osbpm:osbpm1 logfile=210925.log table_exists_action=replace SQL>drop directory mydata; Directory dropped. SQL>exit Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 -64bit Production oracle@99c37c9eaf2a:/$ lsbin boot dev docker-entrypoint-initdb.d entrypoint.shetc home lib lib64 media mnt opt proc root run sbin srv sys tmp u01 usr var oracle@99c37c9eaf2a:/$ cd u01/oracle@99c37c9eaf2a:/u01$ lsapp oracle@99c37c9eaf2a:/u01$ cd app/oracle@99c37c9eaf2a:/u01/app$ lsoraInventory oracle oracle-product oracle@99c37c9eaf2a:/u01/app$ cd ora bash: cd: ora: No such fileor directory oracle@99c37c9eaf2a:/u01/app$ cd oracle oracle@99c37c9eaf2a:/u01/app/oracle$ lsadmin audit cfgtoollogs checkpoints dbs diag fast_recovery_area oradata product oracle@99c37c9eaf2a:/u01/app/oracle$ cd oradata/oracle@99c37c9eaf2a:/u01/app/oracle/oradata$ lsxe oracle@99c37c9eaf2a:/u01/app/oracle/oradata$ cd xe/oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ lscontrol01.ctl devbpm osbpm redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ pwd /u01/app/oracle/oradata/xe oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ mkdirtmpdata oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ lscontrol01.ctl devbpm osbpm redo01.log redo02.log redo03.log sysaux01.dbf system01.dbf temp01.dbf tmpdata undotbs01.dbf users01.dbf oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ ls -al total 2378124drwxrwxrwx 5 oracle dba 221 Sep 25 11:07. drwxrwxrwx 3 oracle dba 16 Jun 20 19:00.. -rwxrwxrwx 1 oracle dba 10141696 Sep 25 11:07control01.ctl drwxr-xr-x 2 oracle dba 52 Aug 16 15:18devbpm drwxrwxrwx 2 root root 50 Jun 20 19:19osbpm -rwxrwxrwx 1 oracle dba 52429312 Sep 25 06:00redo01.log -rwxrwxrwx 1 oracle dba 52429312 Sep 25 08:04redo02.log -rwxrwxrwx 1 oracle dba 52429312 Sep 25 11:06redo03.log -rwxrwxrwx 1 oracle dba 1069555712 Sep 25 11:00sysaux01.dbf -rwxrwxrwx 1 oracle dba 859840512 Sep 25 11:00system01.dbf -rwxrwxrwx 1 oracle dba 206577664 Sep 25 10:01temp01.dbf drwxr-xr-x 2 oracle dba 6 Sep 25 11:07tmpdata -rwxrwxrwx 1 oracle dba 325066752 Sep 25 11:06undotbs01.dbf -rwxrwxrwx 1 oracle dba 5251072 Sep 25 08:34users01.dbf oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ chmod 777 tmpdata/oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ ls -al total 2378124drwxrwxrwx 5 oracle dba 221 Sep 25 11:07. drwxrwxrwx 3 oracle dba 16 Jun 20 19:00.. -rwxrwxrwx 1 oracle dba 10141696 Sep 25 11:07control01.ctl drwxr-xr-x 2 oracle dba 52 Aug 16 15:18devbpm drwxrwxrwx 2 root root 50 Jun 20 19:19osbpm -rwxrwxrwx 1 oracle dba 52429312 Sep 25 06:00redo01.log -rwxrwxrwx 1 oracle dba 52429312 Sep 25 08:04redo02.log -rwxrwxrwx 1 oracle dba 52429312 Sep 25 11:06redo03.log -rwxrwxrwx 1 oracle dba 1069555712 Sep 25 11:00sysaux01.dbf -rwxrwxrwx 1 oracle dba 859840512 Sep 25 11:00system01.dbf -rwxrwxrwx 1 oracle dba 206577664 Sep 25 10:01temp01.dbf drwxrwxrwx 2 oracle dba 6 Sep 25 11:07tmpdata -rwxrwxrwx 1 oracle dba 325066752 Sep 25 11:06undotbs01.dbf -rwxrwxrwx 1 oracle dba 5251072 Sep 25 08:34users01.dbf oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe$ cd tmpdata/oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe/tmpdata$ pwd /u01/app/oracle/oradata/xe/tmpdata oracle@99c37c9eaf2a:/u01/app/oracle/oradata/xe/tmpdata$ exit exit root@99c37c9eaf2a:/# lsbin boot dev docker-entrypoint-initdb.d entrypoint.shetc home lib lib64 media mnt opt proc root run sbin srv sys tmp u01 usr var root@99c37c9eaf2a:/# suoracle oracle@99c37c9eaf2a:/$ $ORACLE_HOME/bin/sqlplus /as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Sep 25 11:08:43 2021 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 -64bit Production SQL>SQL>SQL>SQL> create directory mydata as '/u01/app/oracle/oradata/xe/tmpdata'; Directory created. SQL>SQL>SQL>SQL>exit Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 -64bit Production oracle@99c37c9eaf2a:/$ $ORACLE_HOME/bin/expdp osbpm/xxxx@127.0.0.1/xe directory=mydata schemas=osbpm dumpfile=osbpm210925.dmp logfile=1.log Export: Release 12.1.0.2.0 - Production on Sat Sep 25 11:08:58 2021 Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 -64bit Production Starting "OSBPM"."SYS_EXPORT_SCHEMA_01": osbpm/********@127.0.0.1/xe directory=mydata schemas=osbpm dumpfile=osbpm210925.dmp logfile=1.log Estimate in progress using BLOCKS method... Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 71.68 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 >>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/IDENTITY_COLUMN Processing object type SCHEMA_EXPORT/VIEW/VIEW 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/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER >>> DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled >>> DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled . . exported "OSBPM"."BPM_FORMLIST" 7.364 MB 548 rows . . exported "OSBPM"."BPM_RULELIST" 3.943 MB 892 rows . . exported "OSBPM"."BPM_GRIDLIST" 2.142 MB 320 rows . . exported "OSBPM"."BPM_MODGRAPHICLIST" 1.999 MB 67 rows . . exported "OSBPM"."BPM_DEVLOG" 1.144 MB 150 rows . . exported "OSBPM"."BPM_PAGELIST" 898.3 KB 118 rows . . exported "OSBPM"."BPM_MODTASKLIST" 978 KB 437 rows . . exported "OSBPM"."BPM_TABLECONFIG" 577.2 KB 179 rows . . exported "OSBPM"."BPM_USERACTIONLOG" 47.40 KB 222 rows . . exported "OSBPM"."BPM_DEVDEFAULTCODE" 432.5 KB 107 rows . . exported "OSBPM"."BPM_ATTACHMENTLOG" 33.46 KB 177 rows . . exported "OSBPM"."BPM_DATASOURCELIST" 393.6 KB 223 rows . . exported "OSBPM"."BPM_LOCKDOCLIST" 422.6 KB 4197 rows . . exported "OSBPM"."BPM_NAVTREENODE" 257.3 KB 404 rows . . exported "OSBPM"."BPM_RESTINTERFACELIST" 86.14 KB 134 rows . . exported "OSBPM"."BPM_JAVASCRIPT" 121.9 KB 10 rows . . exported "OSBPM"."BPM_MAINDATA" 21.51 KB 3 rows . . exported "OSBPM"."BPM_REPORTNODELIST" 52.92 KB 16 rows . . exported "OSBPM"."BPM_SUBFORMDATA" 13.35 KB 1 rows . . exported "OSBPM"."BPM_SYSTEMHELP" 197.9 KB 638 rows . . exported "OSBPM"."BPG_MODGRAPHICLIST" 49.95 KB 2 rows . . exported "OSBPM"."BPM_ARCHIVEDGRAPHICLIST" 0 KB 0 rows . . exported "OSBPM"."BPM_CLUSTERSEVERLIST" 0 KB 0 rows . . exported "OSBPM"."BPM_CONSOLEERROR" 0 KB 0 rows . . exported "OSBPM"."BPM_DATASNAPSHOT" 0 KB 0 rows . . exported "OSBPM"."BPM_ELEMENTVERSIONLOG" 0 KB 0 rows . . exported "OSBPM"."BPM_MAILBOX" 0 KB 0 rows . . exported "OSBPM"."BPM_MODSEQUENCEFLOWLIST" 157.7 KB 534 rows . . exported "OSBPM"."BPM_SYSTEMHELPDOC" 68.57 KB 29 rows . . exported "OSBPM"."APP_A001_TRASHLIST" 12.14 KB 4 rows . . exported "OSBPM"."APP_A002_CALENDARLIST" 10.17 KB 1 rows . . exported "OSBPM"."APP_TEMPCRUD" 14.18 KB 2 rows . . exported "OSBPM"."APP_TEMPDOCLIST" 11.71 KB 2 rows . . exported "OSBPM"."BPG_MODEVENTLIST" 10.10 KB 4 rows . . exported "OSBPM"."BPG_MODGATEWAYLIST" 9.312 KB 1 rows . . exported "OSBPM"."BPG_MODPROCESSLIST" 21.44 KB 3 rows . . exported "OSBPM"."BPG_MODSEQUENCEFLOWLIST" 15.72 KB 13 rows . . exported "OSBPM"."BPG_MODSUBPROCESSLIST" 9.679 KB 1 rows . . exported "OSBPM"."BPG_MODTASKLIST" 20.71 KB 6 rows . . exported "OSBPM"."BPM_APPLIST" 53.22 KB 51 rows . . exported "OSBPM"."BPM_APPSYSTEMCONFIG" 0 KB 0 rows . . exported "OSBPM"."BPM_ARCHIVEDDATA" 21.42 KB 2 rows . . exported "OSBPM"."BPM_CONSOLELOG" 0 KB 0 rows . . exported "OSBPM"."BPM_DATAANALYSE" 11.62 KB 1 rows . . exported "OSBPM"."BPM_DATADICVALUELIST" 22.37 KB 9 rows . . exported "OSBPM"."BPM_DATASOURCEACLLIST" 9.203 KB 2 rows . . exported "OSBPM"."BPM_DOCACCESSLOG" 0 KB 0 rows . . exported "OSBPM"."BPM_DOCTRASH" 24.17 KB 9 rows . . exported "OSBPM"."BPM_ELEMENTEDITLOG" 0 KB 0 rows . . exported "OSBPM"."BPM_ENTRUSTLIST" 9.664 KB 1 rows . . exported "OSBPM"."BPM_GRIDCONTROLLIST" 21.64 KB 18 rows . . exported "OSBPM"."BPM_INSCOPYUSERLIST" 0 KB 0 rows . . exported "OSBPM"."BPM_INSNODELIST" 13.89 KB 12 rows . . exported "OSBPM"."BPM_INSSTAYDATA" 0 KB 0 rows . . exported "OSBPM"."BPM_MAILCONFIG" 0 KB 0 rows . . exported "OSBPM"."BPM_MCCONTROLPOINT" 17.09 KB 8 rows . . exported "OSBPM"."BPM_MODEVENTLIST" 48.23 KB 136 rows . . exported "OSBPM"."BPM_MODGATEWAYLIST" 9.617 KB 2 rows . . exported "OSBPM"."BPM_MODPROCESSLIST" 128.2 KB 67 rows . . exported "OSBPM"."BPM_MODSUBPROCESSLIST" 14.81 KB 4 rows . . exported "OSBPM"."BPM_ONLINEUSER" 0 KB 0 rows . . exported "OSBPM"."BPM_ORGDEPTLIST" 21.06 KB 16 rows . . exported "OSBPM"."BPM_ORGROLEMEMBERS" 12.42 KB 16 rows . . exported "OSBPM"."BPM_ORGUSERLIST" 13.53 KB 1 rows . . exported "OSBPM"."BPM_SIGNATURE_UNION" 60.12 KB 3 rows . . exported "OSBPM"."BPM_SIMFORMLIST" 14.22 KB 4 rows . . exported "OSBPM"."BPM_SIMPROCESSLIST" 12.85 KB 6 rows . . exported "OSBPM"."BPM_SMSBOX" 0 KB 0 rows . . exported "OSBPM"."BPM_TEMPLATE" 13.83 KB 6 rows . . exported "OSBPM"."BPM_TODOBOX" 0 KB 0 rows . . exported "OSBPM"."BPM_UIENGINECONFIG" 0 KB 0 rows . . exported "OSBPM"."CFAPP_BURIEDPOINT" 71.53 KB 526 rows . . exported "OSBPM"."APP_A001_RECEIVELIST" 11.78 KB 20 rows . . exported "OSBPM"."APP_A001_SENDLIST" 10.07 KB 15 rows . . exported "OSBPM"."APP_TEMPTREE" 8.992 KB 4 rows . . exported "OSBPM"."BPG_MODPLUGINCONFIG" 13.03 KB 9 rows . . exported "OSBPM"."BPM_APPCONFIG" 14.54 KB 26 rows . . exported "OSBPM"."BPM_APPPLUGINCONFIG" 23.82 KB 44 rows . . exported "OSBPM"."BPM_APPVERSIONLIST" 12.99 KB 33 rows . . exported "OSBPM"."BPM_ARCHIVEDREMARKLIST" 18.47 KB 4 rows . . exported "OSBPM"."BPM_ATTACHMENTSLIST" 10.72 KB 3 rows . . exported "OSBPM"."BPM_BEANCONFIG" 18.81 KB 60 rows . . exported "OSBPM"."BPM_BUSINESSSYSTEM" 8.515 KB 3 rows . . exported "OSBPM"."BPM_DATADICCONFIG" 11.32 KB 1 rows . . exported "OSBPM"."BPM_DATATYPECONFIG" 7.132 KB 4 rows . . exported "OSBPM"."BPM_DEVPLUGINCONFIG" 28.65 KB 98 rows . . exported "OSBPM"."BPM_DEVTYPECONFIG" 15.79 KB 31 rows . . exported "OSBPM"."BPM_DOCFAVORITES" 7.078 KB 7 rows . . exported "OSBPM"."BPM_ELEMENTEXTENDSCONFIG" 9.734 KB 2 rows . . exported "OSBPM"."BPM_ENGINEACTIONCONFIG" 13.71 KB 23 rows . . exported "OSBPM"."BPM_ENGINEBUTTONCONFIG" 20.26 KB 37 rows . . exported "OSBPM"."BPM_ENGINEEVENTCONFIG" 12.19 KB 26 rows . . exported "OSBPM"."BPM_ENGINEEVENTLIST" 11.25 KB 24 rows . . exported "OSBPM"."BPM_ENGINEFORMPLUGINCONFIG" 12.75 KB 11 rows . . exported "OSBPM"."BPM_ENGINENODEATTRPLUGINCONFIG" 16.67 KB 31 rows . . exported "OSBPM"."BPM_ENGINENODEOWNERCONFIG" 9.781 KB 6 rows . . exported "OSBPM"."BPM_ENGINENODETYPECONFIG" 11.31 KB 13 rows . . exported "OSBPM"."BPM_FORMCONTROLATTRIBUTE" 26.76 KB 53 rows . . exported "OSBPM"."BPM_FORMCONTROLLIST" 42.42 KB 53 rows . . exported "OSBPM"."BPM_FORMSELECTORCONFIG" 12.46 KB 8 rows . . exported "OSBPM"."BPM_FORMVALIDTYPECONFIG" 11.99 KB 16 rows . . exported "OSBPM"."BPM_HTMLTAGCONFIG" 12.64 KB 14 rows . . exported "OSBPM"."BPM_INSREMARKLIST" 18.14 KB 3 rows . . exported "OSBPM"."BPM_INSUSERLIST" 21.42 KB 13 rows . . exported "OSBPM"."BPM_INTERNATION" 8.601 KB 24 rows . . exported "OSBPM"."BPM_MCCONTROLPOINTLOG" 16.89 KB 21 rows . . exported "OSBPM"."BPM_MODATTRIBUTECONFIG" 16.60 KB 38 rows . . exported "OSBPM"."BPM_NAVTREELIST" 14.74 KB 38 rows . . exported "OSBPM"."BPM_ORGANIZATION" 6.945 KB 3 rows . . exported "OSBPM"."BPM_ORGROLELIST" 9.476 KB 11 rows . . exported "OSBPM"."BPM_ORGROLETREE" 8.179 KB 14 rows . . exported "OSBPM"."BPM_ORGUSERDEPTMAP" 12.16 KB 57 rows . . exported "OSBPM"."BPM_PROCESSMAPDATA" 11.07 KB 1 rows . . exported "OSBPM"."BPM_REPORTUSERLIST" 19.87 KB 12 rows . . exported "OSBPM"."BPM_SERIALNO" 6.062 KB 2 rows . . exported "OSBPM"."BPM_SIMNODELIST" 10.85 KB 41 rows . . exported "OSBPM"."BPM_SMSCONFIG" 7.914 KB 1 rows . . exported "OSBPM"."BPM_SYSAPPEDITLOG" 7.453 KB 2 rows . . exported "OSBPM"."BPM_SYSTEMCONFIG" 38.05 KB 63 rows . . exported "OSBPM"."BPM_SYSTEMINFO" 10.24 KB 1 rows . . exported "OSBPM"."BPM_TEMPREMARKLIST" 0 KB 0 rows . . exported "OSBPM"."BPM_TIMECONFIG" 11.80 KB 1 rows . . exported "OSBPM"."BPM_USERPROFILE" 7.851 KB 2 rows . . exported "OSBPM"."BPM_WENHAOTYPE" 8.304 KB 2 rows . . exported "OSBPM"."BPM_XTAGCONFIG" 9.359 KB 6 rows . . exported "OSBPM"."BPM_ZHIHAO" 10.70 KB 3 rows . . exported "OSBPM"."CFAPP_ANNOUNCEMENT" 14.60 KB 21 rows . . exported "OSBPM"."CFAPP_COMMONLYUSED" 12.96 KB 19 rows . . exported "OSBPM"."CFAPP_FEEDBACK" 17.82 KB 26 rows . . exported "OSBPM"."CFAPP_LCJGDYB" 22.28 KB 85 rows . . exported "OSBPM"."CFAPP_NODE" 11 KB 9 rows . . exported "OSBPM"."CFAPP_PROBLEM" 21.46 KB 13 rows . . exported "OSBPM"."CFAPP_PROCESSFILE" 0 KB 0 rows . . exported "OSBPM"."CFAPP_RELEVANCE" 22.41 KB 71 rows . . exported "OSBPM"."FT_COMPANY" 0 KB 0 rows . . exported "OSBPM"."FT_MACCBALANCE" 0 KB 0 rows . . exported "OSBPM"."BHDEMO_002" 9.289 KB 3 rows . . exported "OSBPM"."BPM_REPORT_DESIGN" 0 KB 0 rows . . exported "OSBPM"."BPM_UILIST" 10.03 KB 2 rows . . exported "OSBPM"."DATACENTER_TABLE_INFO" 71.10 KB 414 rows . . exported "OSBPM"."FT_COUNTRY" 6.406 KB 2 rows . . exported "OSBPM"."FT_CURRENCY" 6.429 KB 2 rows . . exported "OSBPM"."FT_MACCHANG" 7.726 KB 1 rows . . exported "OSBPM"."FT_MACCREVISE" 8.242 KB 2 rows . . exported "OSBPM"."FT_MONEYACCOUNT" 8.617 KB 1 rows . . exported "OSBPM"."S018_ALIBAO001" 10.14 KB 3 rows . . exported "OSBPM"."S031_THEMELIST" 14.59 KB 4 rows . . exported "OSBPM"."S031_UNIONTHEME" 30.85 KB 14 rows . . exported "OSBPM"."SYSDEMO_001" 9.25 KB 1 rows . . exported "OSBPM"."AA_TEST" 6.867 KB 1 rows . . exported "OSBPM"."APPVERSION_CONFIG" 14.90 KB 24 rows . . exported "OSBPM"."COMPUTER_INFO" 7.593 KB 9 rows . . exported "OSBPM"."DATACENTER_DEPT_INFO" 6.992 KB 26 rows . . exported "OSBPM"."DATACENTER_RESOURCE_INFO" 11.37 KB 4 rows . . exported "OSBPM"."DATACENTER_TABLE_RETRIEVE" 8.023 KB 6 rows . . exported "OSBPM"."DATACENTER_TABLE_SCORE" 10.49 KB 4 rows . . exported "OSBPM"."HISTORICAL_AND_NEW_DELIVER" 6.468 KB 1 rows . . exported "OSBPM"."MILITARY_FUNDS_APPROPRIATE" 6.921 KB 1 rows . . exported "OSBPM"."OVERALL_LEAD_SEAL_AND_DELIVER" 6.445 KB 1 rows . . exported "OSBPM"."OVER_THE_YEARS_PLANE_PROGRESS" 6.218 KB 12 rows . . exported "OSBPM"."SUPPLIER_INFO" 6.218 KB 13 rows . . exported "OSBPM"."SUPPORTING_CONTRACT_SIGN" 6.023 KB 3 rows . . exported "OSBPM"."SUPPORTING_FUNDS_APPROPRIATE" 6.039 KB 3 rows . . exported "OSBPM"."THD_BAS_DIMENSION" 9.187 KB 7 rows . . exported "OSBPM"."THD_REL_FLOW_DIMENSION" 9.109 KB 9 rows . . exported "OSBPM"."THIS_YEAR_SEAL_AND_DELIVER" 7.390 KB 4 rows . . exported "OSBPM"."TROOP_PROGRESS" 8.710 KB 2 rows . . exported "OSBPM"."UNASSIGNED_PLANE_PROGRESS" 6.601 KB 29 rows Master table "OSBPM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded ****************************************************************************** Dump file set for OSBPM.SYS_EXPORT_SCHEMA_01 is: /u01/app/oracle/oradata/xe/tmpdata/osbpm210925.dmp Job "OSBPM"."SYS_EXPORT_SCHEMA_01" successfully completed at Sat Sep 25 11:10:25 2021 elapsed 0 00:01:26 oracle@99c37c9eaf2a:/$ ^C oracle@99c37c9eaf2a:/$ oracle@99c37c9eaf2a:/$ oracle@99c37c9eaf2a:/$ oracle@99c37c9eaf2a:/$ $ORACLE_HOME/bin/sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Sep 25 11:12:40 2021 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production SQL> grant read,write on directory mydata to osbpm1 2 ; Grant succeeded. SQL> exit Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production oracle@99c37c9eaf2a:/$ oracle@99c37c9eaf2a:/$ $ORACLE_HOME/bin/impdp osbpm/xxxx@127.0.0.1/xe directory=mydata dumpfile=osbpm210925.dmp remap_schema=osbpm:osbpm1 logfile=210925.log table_exists_action=replace Import: Release 12.1.0.2.0 - Production on Sat Sep 25 11:16:14 2021 Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production Master table "OSBPM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "OSBPM"."SYS_IMPORT_FULL_01": osbpm/********@127.0.0.1/xe directory=mydata dumpfile=osbpm210925.dmp remap_schema=osbpm:osbpm1 logfile=210925.log table_exists_action=replace Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"OSBPM1" already exists 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/TABLE/TABLE ^C Import> $ORACLE_HOME/bin/impdp osbpm1/xxxx@127.0.0.1/xe directory=mydata dumpfile=osbpm210925.dmp remap_schema=osbpm:osbpm1 logfile=210925.log table_exists_action=replace Import> LRM-00108: invalid positional parameter value 'osbpm1/xxxx@127.0.0.1/xe' Import> $ORACLE_HOME/bin/impdp osbpm1/xxxx@127.0.0.1/xe directory=mydata dumpfile=osbpm210925.dmp remap_schema=osbpm:osbpm1 logfile=210925.log table_exists_action=replace LRM-00108: invalid positional parameter value 'osbpm1/xxxx@127.0.0.1/xe' Import> ^[[A^[[B^H^HCCC^Z^C^C^C Import> Import> Import> ^C^C^C^H Import> eixt UDI-00053: unrecognized client command 'eixt' Import> exit oracle@99c37c9eaf2a:/$ $ORACLE_HOME/bin/impdp osbpm1/xxxx@127.0.0.1/xe directory=mydata dumpfile=osbpm210925.dmp remap_schema=osbpm:osbpm1 logfile=210925.log table_exists_action=replace Import: Release 12.1.0.2.0 - Production on Sat Sep 25 11:17:41 2021 Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production Master table "OSBPM1"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "OSBPM1"."SYS_IMPORT_FULL_01": osbpm1/********@127.0.0.1/xe directory=mydata dumpfile=osbpm210925.dmp remap_schema=osbpm:osbpm1 logfile=210925.log table_exists_action=replace Processing object type SCHEMA_EXPORT/USER ORA-31684: Object type USER:"OSBPM1" already exists 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/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "OSBPM1"."BPM_FORMLIST" 7.364 MB 548 rows . . imported "OSBPM1"."BPM_RULELIST" 3.943 MB 892 rows . . imported "OSBPM1"."BPM_GRIDLIST" 2.142 MB 320 rows . . imported "OSBPM1"."BPM_MODGRAPHICLIST" 1.999 MB 67 rows . . imported "OSBPM1"."BPM_DEVLOG" 1.144 MB 150 rows . . imported "OSBPM1"."BPM_PAGELIST" 898.3 KB 118 rows . . imported "OSBPM1"."BPM_MODTASKLIST" 978 KB 437 rows . . imported "OSBPM1"."BPM_TABLECONFIG" 577.2 KB 179 rows . . imported "OSBPM1"."BPM_USERACTIONLOG" 47.40 KB 222 rows . . imported "OSBPM1"."BPM_DEVDEFAULTCODE" 432.5 KB 107 rows . . imported "OSBPM1"."BPM_ATTACHMENTLOG" 33.46 KB 177 rows . . imported "OSBPM1"."BPM_DATASOURCELIST" 393.6 KB 223 rows . . imported "OSBPM1"."BPM_LOCKDOCLIST" 422.6 KB 4197 rows . . imported "OSBPM1"."BPM_NAVTREENODE" 257.3 KB 404 rows . . imported "OSBPM1"."BPM_RESTINTERFACELIST" 86.14 KB 134 rows . . imported "OSBPM1"."BPM_JAVASCRIPT" 121.9 KB 10 rows . . imported "OSBPM1"."BPM_MAINDATA" 21.51 KB 3 rows . . imported "OSBPM1"."BPM_REPORTNODELIST" 52.92 KB 16 rows . . imported "OSBPM1"."BPM_SUBFORMDATA" 13.35 KB 1 rows . . imported "OSBPM1"."BPM_SYSTEMHELP" 197.9 KB 638 rows . . imported "OSBPM1"."BPG_MODGRAPHICLIST" 49.95 KB 2 rows . . imported "OSBPM1"."BPM_ARCHIVEDGRAPHICLIST" 0 KB 0 rows . . imported "OSBPM1"."BPM_CLUSTERSEVERLIST" 0 KB 0 rows . . imported "OSBPM1"."BPM_CONSOLEERROR" 0 KB 0 rows . . imported "OSBPM1"."BPM_DATASNAPSHOT" 0 KB 0 rows . . imported "OSBPM1"."BPM_ELEMENTVERSIONLOG" 0 KB 0 rows . . imported "OSBPM1"."BPM_MAILBOX" 0 KB 0 rows . . imported "OSBPM1"."BPM_MODSEQUENCEFLOWLIST" 157.7 KB 534 rows . . imported "OSBPM1"."BPM_SYSTEMHELPDOC" 68.57 KB 29 rows . . imported "OSBPM1"."APP_A001_TRASHLIST" 12.14 KB 4 rows . . imported "OSBPM1"."APP_A002_CALENDARLIST" 10.17 KB 1 rows . . imported "OSBPM1"."APP_TEMPCRUD" 14.18 KB 2 rows . . imported "OSBPM1"."APP_TEMPDOCLIST" 11.71 KB 2 rows . . imported "OSBPM1"."BPG_MODEVENTLIST" 10.10 KB 4 rows . . imported "OSBPM1"."BPG_MODGATEWAYLIST" 9.312 KB 1 rows . . imported "OSBPM1"."BPG_MODPROCESSLIST" 21.44 KB 3 rows . . imported "OSBPM1"."BPG_MODSEQUENCEFLOWLIST" 15.72 KB 13 rows . . imported "OSBPM1"."BPG_MODSUBPROCESSLIST" 9.679 KB 1 rows . . imported "OSBPM1"."BPG_MODTASKLIST" 20.71 KB 6 rows . . imported "OSBPM1"."BPM_APPLIST" 53.22 KB 51 rows . . imported "OSBPM1"."BPM_APPSYSTEMCONFIG" 0 KB 0 rows . . imported "OSBPM1"."BPM_ARCHIVEDDATA" 21.42 KB 2 rows . . imported "OSBPM1"."BPM_CONSOLELOG" 0 KB 0 rows . . imported "OSBPM1"."BPM_DATAANALYSE" 11.62 KB 1 rows . . imported "OSBPM1"."BPM_DATADICVALUELIST" 22.37 KB 9 rows . . imported "OSBPM1"."BPM_DATASOURCEACLLIST" 9.203 KB 2 rows . . imported "OSBPM1"."BPM_DOCACCESSLOG" 0 KB 0 rows . . imported "OSBPM1"."BPM_DOCTRASH" 24.17 KB 9 rows . . imported "OSBPM1"."BPM_ELEMENTEDITLOG" 0 KB 0 rows . . imported "OSBPM1"."BPM_ENTRUSTLIST" 9.664 KB 1 rows . . imported "OSBPM1"."BPM_GRIDCONTROLLIST" 21.64 KB 18 rows . . imported "OSBPM1"."BPM_INSCOPYUSERLIST" 0 KB 0 rows . . imported "OSBPM1"."BPM_INSNODELIST" 13.89 KB 12 rows . . imported "OSBPM1"."BPM_INSSTAYDATA" 0 KB 0 rows . . imported "OSBPM1"."BPM_MAILCONFIG" 0 KB 0 rows . . imported "OSBPM1"."BPM_MCCONTROLPOINT" 17.09 KB 8 rows . . imported "OSBPM1"."BPM_MODEVENTLIST" 48.23 KB 136 rows . . imported "OSBPM1"."BPM_MODGATEWAYLIST" 9.617 KB 2 rows . . imported "OSBPM1"."BPM_MODPROCESSLIST" 128.2 KB 67 rows . . imported "OSBPM1"."BPM_MODSUBPROCESSLIST" 14.81 KB 4 rows . . imported "OSBPM1"."BPM_ONLINEUSER" 0 KB 0 rows . . imported "OSBPM1"."BPM_ORGDEPTLIST" 21.06 KB 16 rows . . imported "OSBPM1"."BPM_ORGROLEMEMBERS" 12.42 KB 16 rows . . imported "OSBPM1"."BPM_ORGUSERLIST" 13.53 KB 1 rows . . imported "OSBPM1"."BPM_SIGNATURE_UNION" 60.12 KB 3 rows . . imported "OSBPM1"."BPM_SIMFORMLIST" 14.22 KB 4 rows . . imported "OSBPM1"."BPM_SIMPROCESSLIST" 12.85 KB 6 rows . . imported "OSBPM1"."BPM_SMSBOX" 0 KB 0 rows . . imported "OSBPM1"."BPM_TEMPLATE" 13.83 KB 6 rows . . imported "OSBPM1"."BPM_TODOBOX" 0 KB 0 rows . . imported "OSBPM1"."BPM_UIENGINECONFIG" 0 KB 0 rows . . imported "OSBPM1"."CFAPP_BURIEDPOINT" 71.53 KB 526 rows . . imported "OSBPM1"."APP_A001_RECEIVELIST" 11.78 KB 20 rows . . imported "OSBPM1"."APP_A001_SENDLIST" 10.07 KB 15 rows . . imported "OSBPM1"."APP_TEMPTREE" 8.992 KB 4 rows . . imported "OSBPM1"."BPG_MODPLUGINCONFIG" 13.03 KB 9 rows . . imported "OSBPM1"."BPM_APPCONFIG" 14.54 KB 26 rows . . imported "OSBPM1"."BPM_APPPLUGINCONFIG" 23.82 KB 44 rows . . imported "OSBPM1"."BPM_APPVERSIONLIST" 12.99 KB 33 rows . . imported "OSBPM1"."BPM_ARCHIVEDREMARKLIST" 18.47 KB 4 rows . . imported "OSBPM1"."BPM_ATTACHMENTSLIST" 10.72 KB 3 rows . . imported "OSBPM1"."BPM_BEANCONFIG" 18.81 KB 60 rows . . imported "OSBPM1"."BPM_BUSINESSSYSTEM" 8.515 KB 3 rows . . imported "OSBPM1"."BPM_DATADICCONFIG" 11.32 KB 1 rows . . imported "OSBPM1"."BPM_DATATYPECONFIG" 7.132 KB 4 rows . . imported "OSBPM1"."BPM_DEVPLUGINCONFIG" 28.65 KB 98 rows . . imported "OSBPM1"."BPM_DEVTYPECONFIG" 15.79 KB 31 rows . . imported "OSBPM1"."BPM_DOCFAVORITES" 7.078 KB 7 rows . . imported "OSBPM1"."BPM_ELEMENTEXTENDSCONFIG" 9.734 KB 2 rows . . imported "OSBPM1"."BPM_ENGINEACTIONCONFIG" 13.71 KB 23 rows . . imported "OSBPM1"."BPM_ENGINEBUTTONCONFIG" 20.26 KB 37 rows . . imported "OSBPM1"."BPM_ENGINEEVENTCONFIG" 12.19 KB 26 rows . . imported "OSBPM1"."BPM_ENGINEEVENTLIST" 11.25 KB 24 rows . . imported "OSBPM1"."BPM_ENGINEFORMPLUGINCONFIG" 12.75 KB 11 rows . . imported "OSBPM1"."BPM_ENGINENODEATTRPLUGINCONFIG" 16.67 KB 31 rows . . imported "OSBPM1"."BPM_ENGINENODEOWNERCONFIG" 9.781 KB 6 rows . . imported "OSBPM1"."BPM_ENGINENODETYPECONFIG" 11.31 KB 13 rows . . imported "OSBPM1"."BPM_FORMCONTROLATTRIBUTE" 26.76 KB 53 rows . . imported "OSBPM1"."BPM_FORMCONTROLLIST" 42.42 KB 53 rows . . imported "OSBPM1"."BPM_FORMSELECTORCONFIG" 12.46 KB 8 rows . . imported "OSBPM1"."BPM_FORMVALIDTYPECONFIG" 11.99 KB 16 rows . . imported "OSBPM1"."BPM_HTMLTAGCONFIG" 12.64 KB 14 rows . . imported "OSBPM1"."BPM_INSREMARKLIST" 18.14 KB 3 rows . . imported "OSBPM1"."BPM_INSUSERLIST" 21.42 KB 13 rows . . imported "OSBPM1"."BPM_INTERNATION" 8.601 KB 24 rows . . imported "OSBPM1"."BPM_MCCONTROLPOINTLOG" 16.89 KB 21 rows . . imported "OSBPM1"."BPM_MODATTRIBUTECONFIG" 16.60 KB 38 rows . . imported "OSBPM1"."BPM_NAVTREELIST" 14.74 KB 38 rows . . imported "OSBPM1"."BPM_ORGANIZATION" 6.945 KB 3 rows . . imported "OSBPM1"."BPM_ORGROLELIST" 9.476 KB 11 rows . . imported "OSBPM1"."BPM_ORGROLETREE" 8.179 KB 14 rows . . imported "OSBPM1"."BPM_ORGUSERDEPTMAP" 12.16 KB 57 rows . . imported "OSBPM1"."BPM_PROCESSMAPDATA" 11.07 KB 1 rows . . imported "OSBPM1"."BPM_REPORTUSERLIST" 19.87 KB 12 rows . . imported "OSBPM1"."BPM_SERIALNO" 6.062 KB 2 rows . . imported "OSBPM1"."BPM_SIMNODELIST" 10.85 KB 41 rows . . imported "OSBPM1"."BPM_SMSCONFIG" 7.914 KB 1 rows . . imported "OSBPM1"."BPM_SYSAPPEDITLOG" 7.453 KB 2 rows . . imported "OSBPM1"."BPM_SYSTEMCONFIG" 38.05 KB 63 rows . . imported "OSBPM1"."BPM_SYSTEMINFO" 10.24 KB 1 rows . . imported "OSBPM1"."BPM_TEMPREMARKLIST" 0 KB 0 rows . . imported "OSBPM1"."BPM_TIMECONFIG" 11.80 KB 1 rows . . imported "OSBPM1"."BPM_USERPROFILE" 7.851 KB 2 rows . . imported "OSBPM1"."BPM_WENHAOTYPE" 8.304 KB 2 rows . . imported "OSBPM1"."BPM_XTAGCONFIG" 9.359 KB 6 rows . . imported "OSBPM1"."BPM_ZHIHAO" 10.70 KB 3 rows . . imported "OSBPM1"."CFAPP_ANNOUNCEMENT" 14.60 KB 21 rows . . imported "OSBPM1"."CFAPP_COMMONLYUSED" 12.96 KB 19 rows . . imported "OSBPM1"."CFAPP_FEEDBACK" 17.82 KB 26 rows . . imported "OSBPM1"."CFAPP_LCJGDYB" 22.28 KB 85 rows . . imported "OSBPM1"."CFAPP_NODE" 11 KB 9 rows . . imported "OSBPM1"."CFAPP_PROBLEM" 21.46 KB 13 rows . . imported "OSBPM1"."CFAPP_PROCESSFILE" 0 KB 0 rows . . imported "OSBPM1"."CFAPP_RELEVANCE" 22.41 KB 71 rows . . imported "OSBPM1"."FT_COMPANY" 0 KB 0 rows . . imported "OSBPM1"."FT_MACCBALANCE" 0 KB 0 rows . . imported "OSBPM1"."BHDEMO_002" 9.289 KB 3 rows . . imported "OSBPM1"."BPM_REPORT_DESIGN" 0 KB 0 rows . . imported "OSBPM1"."BPM_UILIST" 10.03 KB 2 rows . . imported "OSBPM1"."DATACENTER_TABLE_INFO" 71.10 KB 414 rows . . imported "OSBPM1"."FT_COUNTRY" 6.406 KB 2 rows . . imported "OSBPM1"."FT_CURRENCY" 6.429 KB 2 rows . . imported "OSBPM1"."FT_MACCHANG" 7.726 KB 1 rows . . imported "OSBPM1"."FT_MACCREVISE" 8.242 KB 2 rows . . imported "OSBPM1"."FT_MONEYACCOUNT" 8.617 KB 1 rows . . imported "OSBPM1"."S018_ALIBAO001" 10.14 KB 3 rows . . imported "OSBPM1"."S031_THEMELIST" 14.59 KB 4 rows . . imported "OSBPM1"."S031_UNIONTHEME" 30.85 KB 14 rows . . imported "OSBPM1"."SYSDEMO_001" 9.25 KB 1 rows . . imported "OSBPM1"."AA_TEST" 6.867 KB 1 rows . . imported "OSBPM1"."APPVERSION_CONFIG" 14.90 KB 24 rows . . imported "OSBPM1"."COMPUTER_INFO" 7.593 KB 9 rows . . imported "OSBPM1"."DATACENTER_DEPT_INFO" 6.992 KB 26 rows . . imported "OSBPM1"."DATACENTER_RESOURCE_INFO" 11.37 KB 4 rows . . imported "OSBPM1"."DATACENTER_TABLE_RETRIEVE" 8.023 KB 6 rows . . imported "OSBPM1"."DATACENTER_TABLE_SCORE" 10.49 KB 4 rows . . imported "OSBPM1"."HISTORICAL_AND_NEW_DELIVER" 6.468 KB 1 rows . . imported "OSBPM1"."MILITARY_FUNDS_APPROPRIATE" 6.921 KB 1 rows . . imported "OSBPM1"."OVERALL_LEAD_SEAL_AND_DELIVER" 6.445 KB 1 rows . . imported "OSBPM1"."OVER_THE_YEARS_PLANE_PROGRESS" 6.218 KB 12 rows . . imported "OSBPM1"."SUPPLIER_INFO" 6.218 KB 13 rows . . imported "OSBPM1"."SUPPORTING_CONTRACT_SIGN" 6.023 KB 3 rows . . imported "OSBPM1"."SUPPORTING_FUNDS_APPROPRIATE" 6.039 KB 3 rows . . imported "OSBPM1"."THD_BAS_DIMENSION" 9.187 KB 7 rows . . imported "OSBPM1"."THD_REL_FLOW_DIMENSION" 9.109 KB 9 rows . . imported "OSBPM1"."THIS_YEAR_SEAL_AND_DELIVER" 7.390 KB 4 rows . . imported "OSBPM1"."TROOP_PROGRESS" 8.710 KB 2 rows . . imported "OSBPM1"."UNASSIGNED_PLANE_PROGRESS" 6.601 KB 29 rows Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/TABLE/IDENTITY_COLUMN ORA-39083: Object type IDENTITY_COLUMN:"OSBPM1" failed to create with error: ORA-00942: table or view does not exist Failing sql is: ALTER TABLE "OSBPM1"."BIN$zIJRwaNJMn3gUwoAEazsng==$0" MODIFY ("ID" GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH LIMIT VALUE CACHE 20 ORDER NOCYCLE ) Processing object type SCHEMA_EXPORT/VIEW/VIEW ORA-31684: Object type VIEW:"OSBPM1"."BPM_ALLDOCUMENT" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ALLELEMENTFORROLES" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ALLELEMENTLIST" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ALLMODNODELIST" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ALLREMARKLIST" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ORGROLEMEMBERSALL" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ORGUSERWITHALLDEPT" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ORGUSERWITHMAINDEPT" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_USERREADDOC" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_USERTODO" already exists ORA-31684: Object type VIEW:"OSBPM1"."BPM_ALLDOCFAVORITES" already exists 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/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/STATISTICS/MARKER Job "OSBPM1"."SYS_IMPORT_FULL_01" completed with 13 error(s) at Sat Sep 25 11:19:13 2021 elapsed 0 00:01:32
记录一下，用impdp导入 expdp导出数据的详细过程
参考 https://blog.csdn.net/m0_37814112/article/details/78119212
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation
解决：重新创建备份目录
1.1先删除原先创建的备份目录
SQL> drop directory kmdata_exp ;
1.2 重新创建新的备份目录
SQL> create or replace directory kmdata_exp as '/u01/app/oracle/backup ';
Directory created.
SQL> grant read,write on directory kmdata_exp to public ;
1.3 修改备份目录的属主和属组
[root@oracle-rac01 ~]# mkdir /u01/app/backup/
[root@oracle-rac01 ~]# chown -R oracle:oinstall /u01/app/oracle/backup/
参考：https://blog.csdn.net/gty931008/article/details/86160808
expdp/impdp 数据泵导入导出
小关enter 2019-01-09 18:37:21 86022 收藏 220
分类专栏： oracle 文章标签： 数据泵 impdp expdp
版权
oracle
专栏收录该内容
1 篇文章1 订阅
订阅专栏
业务场景：
在工作中，涉及到oracle数据库迁移，使用navicat等其他工具 容易报错，一系列问题很麻烦，今天记录一下操作流程及个人理解（文章参考了很多文档和博客）；
EXPDP数据导出
请自行修改目录路径和自定义的表名，否则出现错误很难查找~
一般expdp流程：
一、新建逻辑目录
最好以system等管理员创建逻辑目录，Oracle不会自动创建实际的物理目录“D:oracleData”（务必手动创建此目录），仅仅是进行定义逻辑路径dump_dir；
忘记sys用户密码的可以去下如何修改sys用户密码；
建议使用pl、navicat等oracle操作工具来操作；
登陆后sql执行：
create directory mydata as '逻辑目录路径';
例如：
create directory mydata as '/data/oracle/oradata/mydata';
二、查看逻辑目录是否创建成功
执行sql：
sql>select * from dba_directories
三、用expdp导出数据
用法及解释：
expdp 用户名/密码@ip地址/实例 [属性]
ip地址不写默认就是本地
userid=test/test --导出的用户，本地用户!!
directory=dmpfile --导出的逻辑目录，一定要在oracle中创建完成的，并且给用户授权读写权限
dumpfile=xx.dmp --导出的数据文件的名称，如果想在指定的位置的话可以写成dumpfile=/home/oracle/userxx.dmp
logfile=xx.log --日志文件，如果不写这个参数的话默认名称就是export.log，可以在本地的文件夹中找到
schemas=userxx --使用dblink导出的用户不是本地的用户，需要加上schema来确定导出的用户，类似于exp中的owner，但还有一定的区别
EXCLUDE=TABLE:"IN('T1','T2','T3')" --exclude 可以指定不导出的东西，table，index等，后面加上不想导出的表名
network_link=db_local --这个参数是使用的dblink来远程导出，需要指定dblink的名称
列出一些场景：
1)导出用户及其对象
expdp scott/tiger@orcl schemas=scott dumpfile=expdp.dmp directory=dump_dir logfile=expdp.log;
2)导出指定表
expdp scott/tiger@orcl tables=emp,dept dumpfile=expdp.dmp directory=dump_dir logfile=expdp.log;
3)按查询条件导
expdp scott/tiger@orcl directory=dump_dir dumpfile=expdp.dmp tables=empquery='where deptno=20' logfile=expdp.log;
4)按表空间导
expdp system/manager@orcl directory=dump_dir dumpfile=tablespace.dmp tablespaces=temp,example logfile=expdp.log;
5)导整个数据库
expdp scott/123@127.0.0.1/orcl directory=dump_dir dumpfile=ly.dmp full=y logfile=expdp.log;
一般用的都是导出整个数据库，本人使用的代码：
//包含所有用户的表、视图、索引等
expdp JCPT/123@127.0.0.1/orcl directory=mydata dumpfile=ly.dmp full=y logfile=expdp.log;
//指定用户的表、视图、索引等
expdp JCPT/123@127.0.0.1/orcl directory=mydata schemas=jcpt dumpfile=ly.dmp logfile=expdp.log;
导出完成后：逻辑目录生成了一个 dmp文件；
IMPDP数据导入
在正式导入数据前，要先确保要导入的用户已存在，如果没有存在，请先用下述命令进行新建用户
流程：
一、创建表空间
使用system登录oracle，执行sql
格式: create tablespace 表间名 datafile '数据文件名' size 表空间大小
create tablespace data_test datafile 'e:oracleoradata est est.dbf' size 2000M;
(*数据文件名 包含全路径, 表空间大小 2000M 表是 2000兆)
二、创建用户并授权
格式: create user 用户名 identified by 密码 default tablespace 表空间表;
create user study identified by study default tablespace data_test;
(*我们创建一个用户名为 study,密码为 study, 表空间为 madate-这是在上一步建好的.)
授权给 用户 study ，执行sql
#给用户逻辑目录读写权限
sql>grant read,write on directory mydata to study;
#给用户表空间权限
sql>grant dba,resource,unlimited tablespace to study;
三、impdp导入
命令在cmd或者控制台输入，不是sql语句
写法：
impdp 用户名/密码@ip地址/实例 [属性]
ip地址不写默认就是本地
注释：
1)导入用户（从用户scott导入到用户scott）
impdp scott/tiger@orcl directory=dump_dir dumpfile=expdp.dmp schemas=scott logfile=impdp.log;
2)导入表（从scott用户中把表dept和emp导入到system用户中）
impdp system/manager@orcl directory=dump_dir dumpfile=expdp.dmp tables=scott.dept,scott.emp remap_schema=scott:system logfile=impdp.log table_exists_action=replace (表空间已存在则替换);
3)导入表空间
impdp system/manager@orcl directory=dump_dir dumpfile=tablespace.dmp tablespaces=example logfile=impdp.log;
4)导入整个数据库
impdb system/manager@orcl directory=dump_dir dumpfile=full.dmp full=y logfile=impdp.log;
日常使用的：
把用户jcpt中所有的表导入到lyxt用户下
impdp lyxt/lyxt123@127.0.0.1/orcl directory=mydata dumpfile=LY.DMP remap_schema=jcpt:lyxt logfile=ims20171122.log table_exists_action=replace
5)追加数据
impdp system/manager@orcl directory=dump_dir dumpfile=expdp.dmp schemas=systemtable_exists_action logfile=impdp.log;
以上是日常工作中实际工作中用到的，希望能够给你得到帮助。
————————————————
版权声明：本文为CSDN博主「小关enter」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/gty931008/article/details/86160808