\u767b\u5f55non-CDB\uff0c\u521b\u5efa\u6570\u636e<\/p>\n
[oracle@cat1 ~]$ export ORACLE_SID=orcl1\n[oracle@cat1 ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 30 14:47:57 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL> create user test identified by test;\n\nUser created.\n\nSQL> grant dba to test;\n\nGrant succeeded.\n\nSQL> conn test\/test\nConnected.\nSQL> create table test1 as select * from dba_tables;\n\nTable created.\n\nSQL> select count(*) from dba_tables;\n\n COUNT(*)\n----------\n 2179\n\nSQL> <\/code><\/pre>\n2\u3001\u5bfc\u51fanon-CDB\u6570\u636e<\/h2>\n
\u521b\u5efa\u8def\u5f84<\/p>\n
SQL> conn system\/oracle\nConnected.\nSQL> create directory for_exp as '\/tmp';\n\nDirectory created.<\/code><\/pre>\n\u4fee\u6539\u4e3a\u53ea\u8bfb\u6a21\u5f0f<\/p>\n
SQL> select tablespace_name from dba_tablespaces;\n\nTABLESPACE_NAME\n--------------------------------------------------------------------------------\nSYSTEM\nSYSAUX\nUNDOTBS1\nTEMP\nUSERS\nUNDOTBS2\n\n6 rows selected.\n\nSQL> alter tablespace users read only;\n\nTablespace altered.\n\nSQL> <\/code><\/pre>\n\u5bfc\u51fa\u6570\u636e<\/p>\n
[oracle@cat1 ~]$ expdp system\/oracle directory=for_exp dumpfile=expfull.dmp full=y transportable=always logfile=exp.log\n\nExport: Release 19.0.0.0.0 - Production on Mon Nov 30 14:59:23 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nUDE-28002: operation generated ORACLE error 28002\nORA-28002: the password will expire within 7 days\n\nConnected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nStarting "SYSTEM"."SYS_EXPORT_FULL_02": system\/******** directory=for_exp dumpfile=expfull.dmp full=y transportable=always logfile=exp.log \nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE_DATA\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE_DATA\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/STATISTICS\/TABLE_STATISTICS\nProcessing object type DATABASE_EXPORT\/STATISTICS\/MARKER\nProcessing object type DATABASE_EXPORT\/PLUGTS_FULL\/FULL\/PLUGTS_TABLESPACE\nProcessing object type DATABASE_EXPORT\/PLUGTS_FULL\/PLUGTS_BLK\nProcessing object type DATABASE_EXPORT\/END_PLUGTS_BLK\nProcessing object type DATABASE_EXPORT\/PRE_SYSTEM_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/PRE_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/TABLESPACE\nProcessing object type DATABASE_EXPORT\/PROFILE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/USER\nProcessing object type DATABASE_EXPORT\/RADM_FPTM\nProcessing object type DATABASE_EXPORT\/GRANT\/SYSTEM_GRANT\/PROC_SYSTEM_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/GRANT\/SYSTEM_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ROLE_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/DEFAULT_ROLE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ON_USER_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLESPACE_QUOTA\nProcessing object type DATABASE_EXPORT\/RESOURCE_COST\nProcessing object type DATABASE_EXPORT\/TRUSTED_DB_LINK\nProcessing object type DATABASE_EXPORT\/DIRECTORY\/DIRECTORY\nProcessing object type DATABASE_EXPORT\/DIRECTORY\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PRE_SYSTEM_ACTIONS\/PROCACT_SYSTEM\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PROCOBJ\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/POST_SYSTEM_ACTIONS\/PROCACT_SYSTEM\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCACT_SCHEMA\nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE\nProcessing object type DATABASE_EXPORT\/EARLY_POST_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE\nProcessing object type DATABASE_EXPORT\/NORMAL_POST_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/COMMENT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/INDEX\nProcessing object type DATABASE_EXPORT\/FINAL_POST_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/AUDIT_UNIFIED\/AUDIT_POLICY_ENABLE\nProcessing object type DATABASE_EXPORT\/POST_SYSTEM_IMPCALLOUT\/MARKER\n. . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.070 KB 37 rows\n. . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows\n. . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows\n. . exported "WMSYS"."WM$HINT_TABLE$" 9.984 KB 97 rows\n. . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows\n. . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows\n. . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows\n. . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows\n. . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows\n. . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows\n. . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows\n. . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows\n. . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows\n. . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows\n. . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows\n. . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows\n. . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows\n. . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 122.7 KB 150 rows\n. . exported "AUDSYS"."AUD$UNIFIED":"SYS_P201" 51.90 KB 2 rows\n. . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$POL" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$USER" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows\n. . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows\n. . exported "SYS"."AUD$" 0 KB 0 rows\n. . exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows\n. . exported "SYS"."DAM_CLEANUP_JOBS$" 0 KB 0 rows\n. . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows\n. . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows\n. . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows\n. . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows\n. . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows\n. . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows\n. . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows\n. . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows\n. . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows\n. . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows\n. . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows\n. . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows\n. . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows\n. . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows\n. . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows\n. . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows\n. . exported "MDSYS"."RDF_PARAM$" 6.515 KB 3 rows\n. . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows\n. . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows\n. . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows\n. . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows\n. . exported "SYS"."NACL$_ACE_EXP" 0 KB 0 rows\n. . exported "SYS"."NACL$_HOST_EXP" 6.976 KB 2 rows\n. . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows\n. . exported "SYS"."SQL$TEXT_DATAPUMP" 0 KB 0 rows\n. . exported "SYS"."SQL$_DATAPUMP" 0 KB 0 rows\n. . exported "SYS"."SQLOBJ$AUXDATA_DATAPUMP" 0 KB 0 rows\n. . exported "SYS"."SQLOBJ$DATA_DATAPUMP" 0 KB 0 rows\n. . exported "SYS"."SQLOBJ$PLAN_DATAPUMP" 0 KB 0 rows\n. . exported "SYS"."SQLOBJ$_DATAPUMP" 0 KB 0 rows\n. . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows\n. . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows\n. . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows\n. . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows\n. . exported "SYSTEM"."SYS_EXPORT_FULL_01" 0 KB 0 rows\nMaster table "SYSTEM"."SYS_EXPORT_FULL_02" successfully loaded\/unloaded\n******************************************************************************\nDump file set for SYSTEM.SYS_EXPORT_FULL_02 is:\n \/tmp\/expfull.dmp\n******************************************************************************\nDatafiles required for transportable tablespace USERS:\n +DATA\/ORCL\/DATAFILE\/users.267.1051309053 \u300a===\u6ce8\u610f\u8fd9\u4e2a\u5730\u65b9\u7684\u6570\u636e\u6587\u4ef6\uff0c\u9700\u8981cp\u5230pdb\u7684\u6570\u636e\u6587\u4ef6\u8def\u5f84\u4e0b\nJob "SYSTEM"."SYS_EXPORT_FULL_02" successfully completed at Mon Nov 30 15:01:45 2020 elapsed 0 00:02:20<\/code><\/pre>\n3\u3001\u767b\u5f55PDB\uff0c\u521b\u5efa\u8def\u5f84<\/h2>\n[oracle@cat1 admin]$ sqlplus system\/oracle@PDB2_WHS\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 30 15:08:59 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n\nLast Successful login time: Sun May 01 2005 21:15:47 +08:00\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL> create directory for_exp as '\/tmp';\n\nDirectory created.<\/code><\/pre>\n\u67e5\u770b\u8868\u7a7a\u95f4\uff0c\u5df2\u7ecf\u5b58\u5728users\u8868\u7a7a\u95f4\uff0c\u5c06\u5176rename\u4e3ausers02<\/p>\n
SQL> select tablespace_name from dba_tablespaces;\n\nTABLESPACE_NAME\n--------------------------------------------------------------------------------\nSYSTEM\nSYSAUX\nUNDOTBS1\nTEMP\nUNDO_2\nUSERS\n\nSQL> alter tablespace users rename to user02;<\/code><\/pre>\n\u67e5\u770bPDB\u6570\u636e\u6587\u4ef6\u8def\u5f84:<\/p>\n
SQL> select file_name from dba_data_files;\n\nFILE_NAME\n--------------------------------------------------------------------------------\n+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/users.280.1057335893\n+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/undo_2.279.1057335893\n+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/undotbs1.281.1057335893\n+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/sysaux.283.1057335893\n+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/system.282.1057335893<\/code><\/pre>\n\u62f7\u8d1d\u6570\u636e\u6587\u4ef6<\/p>\n
ASMCMD> cp +DATA\/ORCL\/DATAFILE\/users.267.1051309053 +DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/users_1.dbf\ncopying +DATA\/ORCL\/DATAFILE\/users.267.1051309053 -> +DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/users_1.dbf<\/code><\/pre>\n4\u3001\u5bfc\u5165\u6570\u636e<\/h2>\n[oracle@cat1 tmp]$ impdp system\/oracle@PDB2_WHS directory=for_exp full=y dumpfile=expfull.dmp transport_datafiles='+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/users_1.dbf' logfile=imp.log cluster=N\n\nImport: Release 19.0.0.0.0 - Production on Mon Nov 30 15:34:17 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nConnected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nORA-39002: invalid operation\nORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS [SELECT old_value FROM "SYSTEM"."SYS_IMPORT_FULL_01" WHERE process_order = :1] \nORA-25153: Temporary Tablespace is Empty\n\nORA-06512: at "SYS.DBMS_SYS_ERROR", line 95\nORA-06512: at "SYS.KUPW$WORKER", line 12613\nORA-06512: at "SYS.DBMS_SYS_ERROR", line 95\nORA-06512: at "SYS.DBMS_LOB", line 741\nORA-06512: at "SYS.KUPW$WORKER", line 13683\n\n----- PL\/SQL Call Stack -----\n object line object\n handle number name\n0x63dba548 33476 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION\n0x63dba548 12641 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR\n0x63dba548 13961 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS\n0x63dba548 2429 package body SYS.KUPW$WORKER.MAIN\n0x63e78870 2 anonymous block\n\nKUPW: In procedure DISPATCH_WORK_ITEMS\nKUPW: Open Cursor Check took 0 seconds\nKUPW: In procedure SEND_MSG. Fatal=0\nKUPC$QUEUE.TRANSCEIVE\nKUPC$QUEUE.TRANSCEIVE\nKUPW: Saved debug_info: 0\nKUPW: Master debug flags: 0\nKUPW: Current debug_info: 0\nDBMS_LOB.CREATETEMPORARY v_md_xml_clob\nKUPW: In procedure DETERMINE_FATAL_ERROR with ORA-25153: Temporary Tablespace is Empty\nORA-06512: at "SYS.DBMS_LOB", line 741<\/code><\/pre>\n\u4ee5\u4e0a\u62a5\u9519\u6ca1\u6709\u4e34\u65f6\u8868\u7a7a\u95f4\uff0c\u786e\u8ba4\u67e5\u770b\uff1a<\/p>\n
[oracle@cat1 ~]$ sqlplus system\/oracle@PDB2_WHS\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 30 15:36:28 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n\nLast Successful login time: Mon Nov 30 2020 15:34:17 +08:00\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL> select tablespace_name,status from dba_tablespaces where tablespace_name='TEMP';\n\nTABLESPACE_NAME\n--------------------------------------------------------------------------------\nSTATUS\n---------------------------\nTEMP\nONLINE\n\nSQL> select file_name,tablespace_name from dba_temp_files;\n\nno rows selected<\/code><\/pre>\n\u786e\u5b9e\u6ca1\u6709\u6570\u636e\u6587\u4ef6\uff0c\u624b\u52a8\u589e\u52a0\u6570\u636e\u6587\u4ef6<\/p>\n
SQL> alter tablespace temp add tempfile '+DATA1' SIZE 1g AUTOEXTEND OFF;\n\nTablespace altered.\n\nSQL> select file_name,tablespace_name from dba_temp_files;\n\nFILE_NAME\n--------------------------------------------------------------------------------\nTABLESPACE_NAME\n--------------------------------------------------------------------------------\n+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/TEMPFILE\/temp.301.1057851553\nTEMP<\/code><\/pre>\n\u5bfc\u5165\u6570\u636e<\/strong><\/p>\n[oracle@cat1 tmp]$ impdp system\/oracle@PDB2_WHS directory=for_exp full=y dumpfile=expfull.dmp transport_datafiles='+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/users_1.dbf' logfile=imp.log cluster=N\n\nImport: Release 19.0.0.0.0 - Production on Mon Nov 30 15:45:20 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nConnected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nMaster table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded\/unloaded\nStarting "SYSTEM"."SYS_IMPORT_FULL_01": system\/********@PDB2_WHS directory=for_exp full=y dumpfile=expfull.dmp transport_datafiles=+DATA1\/WHS1\/B4D6EBAED583686DE0532900A8C0FDBB\/DATAFILE\/users_1.dbf logfile=imp.log cluster=N \nProcessing object type DATABASE_EXPORT\/PRE_SYSTEM_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/PRE_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/PLUGTS_FULL\/PLUGTS_BLK\nProcessing object type DATABASE_EXPORT\/TABLESPACE\nORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists\n\nORA-31684: Object type TABLESPACE:"TEMP" already exists\n\nProcessing object type DATABASE_EXPORT\/PROFILE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/USER\nProcessing object type DATABASE_EXPORT\/RADM_FPTM\nProcessing object type DATABASE_EXPORT\/GRANT\/SYSTEM_GRANT\/PROC_SYSTEM_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/GRANT\/SYSTEM_GRANT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ROLE_GRANT\nORA-39083: Object type ROLE_GRANT failed to create with error:\nORA-01917: user or role 'GSMROOTUSER' does not exist\n\nFailing sql is:\n GRANT "GSMROOTUSER_ROLE" TO "GSMROOTUSER"\n\nProcessing object type DATABASE_EXPORT\/SCHEMA\/DEFAULT_ROLE\nORA-39083: Object type DEFAULT_ROLE:"GSMROOTUSER" failed to create with error:\nORA-01918: user 'GSMROOTUSER' does not exist\n\nFailing sql is:\n ALTER USER "GSMROOTUSER" DEFAULT ROLE ALL\n\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ON_USER_GRANT\nORA-39083: Object type ON_USER_GRANT failed to create with error:\nORA-31625: Schema GSMROOTUSER is needed to import this object, but is unaccessible\nORA-01435: user does not exist\n\nFailing sql is:\n GRANT INHERIT PRIVILEGES ON USER "GSMROOTUSER" TO "PUBLIC"\n\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLESPACE_QUOTA\nProcessing object type DATABASE_EXPORT\/RESOURCE_COST\nProcessing object type DATABASE_EXPORT\/TRUSTED_DB_LINK\nProcessing object type DATABASE_EXPORT\/DIRECTORY\/DIRECTORY\nORA-31684: Object type DIRECTORY:"FOR_EXP" already exists\n\nProcessing object type DATABASE_EXPORT\/DIRECTORY\/GRANT\/OWNER_GRANT\/OBJECT_GRANT\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PRE_SYSTEM_ACTIONS\/PROCACT_SYSTEM\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PROCOBJ\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/POST_SYSTEM_ACTIONS\/PROCACT_SYSTEM\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCACT_SCHEMA\nORA-39083: Object type PROCACT_SCHEMA failed to create with error:\nORA-31625: Schema GSMROOTUSER is needed to import this object, but is unaccessible\nORA-01435: user does not exist\n\nFailing sql is:\nBEGIN \nsys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ORCL', inst_scn=>'2070080');COMMIT; END; \n\nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE\nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\n. . imported "SYS"."KU$_EXPORT_USER_MAP" 6.070 KB 37 rows\nProcessing object type DATABASE_EXPORT\/EARLY_POST_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE_DATA\n. . imported "SYSTEM"."REDO_DB_TMP" 25.59 KB 1 rows\n. . imported "WMSYS"."E$WORKSPACES_TABLE$" 12.10 KB 1 rows\n. . imported "WMSYS"."E$HINT_TABLE$" 9.984 KB 97 rows\n. . imported "WMSYS"."E$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows\n. . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM$" 6.531 KB 14 rows\n. . imported "SYS"."DP$TSDP_SUBPOL$" 6.328 KB 1 rows\n. . imported "WMSYS"."E$NEXTVER_TABLE$" 6.375 KB 1 rows\n. . imported "WMSYS"."E$ENV_VARS$" 6.015 KB 3 rows\n. . imported "SYS"."DP$TSDP_PARAMETER$" 5.953 KB 1 rows\n. . imported "SYS"."DP$TSDP_POLICY$" 5.921 KB 1 rows\n. . imported "WMSYS"."E$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows\n. . imported "WMSYS"."E$EVENTS_INFO$" 5.812 KB 12 rows\n. . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"AUD_UNIFIED_P0" 122.7 KB 150 rows\n. . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"SYS_P201" 51.90 KB 2 rows\n. . imported "LBACSYS"."OLS_DP$OLS$AUDIT" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$COMPARTMENTS" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$GROUPS" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$LAB" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$LEVELS" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$POL" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$POLS" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$POLT" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$PROFILE" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$PROG" 0 KB 0 rows\n. . imported "LBACSYS"."OLS_DP$OLS$USER" 0 KB 0 rows\n. . imported "SYS"."AMGT$DP$AUD$" 0 KB 0 rows\n. . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS$" 0 KB 0 rows\n. . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS$" 0 KB 0 rows\n. . imported "SYS"."DP$TSDP_ASSOCIATION$" 0 KB 0 rows\n. . imported "SYS"."DP$TSDP_CONDITION$" 0 KB 0 rows\n. . imported "SYS"."DP$TSDP_FEATURE_POLICY$" 0 KB 0 rows\n. . imported "SYS"."DP$TSDP_PROTECTION$" 0 KB 0 rows\n. . imported "SYS"."DP$TSDP_SENSITIVE_DATA$" 0 KB 0 rows\n. . imported "SYS"."DP$TSDP_SENSITIVE_TYPE$" 0 KB 0 rows\n. . imported "SYS"."DP$TSDP_SOURCE$" 0 KB 0 rows\n. . imported "SYSTEM"."REDO_LOG_TMP" 0 KB 0 rows\n. . imported "WMSYS"."E$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows\n. . imported "WMSYS"."E$CONSTRAINTS_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$CONS_COLUMNS$" 0 KB 0 rows\n. . imported "WMSYS"."E$LOCKROWS_INFO$" 0 KB 0 rows\n. . imported "WMSYS"."E$MODIFIED_TABLES$" 0 KB 0 rows\n. . imported "WMSYS"."E$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$NESTED_COLUMNS_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$RIC_LOCKING_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$RIC_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$RIC_TRIGGERS_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows\n. . imported "WMSYS"."E$UDTRIG_INFO$" 0 KB 0 rows\n. . imported "WMSYS"."E$VERSION_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$VT_ERRORS_TABLE$" 0 KB 0 rows\n. . imported "WMSYS"."E$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\n. . imported "MDSYS"."RDF_PARAM$TBL" 6.515 KB 3 rows\n. . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows\n. . imported "SYS"."DP$DBA_SENSITIVE_DATA" 0 KB 0 rows\n. . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows\n. . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT" 0 KB 0 rows\n. . imported "SYS"."NACL$_ACE_IMP" 0 KB 0 rows\n. . imported "SYS"."NACL$_HOST_IMP" 6.976 KB 2 rows\n. . imported "SYS"."NACL$_WALLET_IMP" 0 KB 0 rows\n. . imported "SYS"."DATAPUMP$SQL$TEXT" 0 KB 0 rows\n. . imported "SYS"."DATAPUMP$SQL$" 0 KB 0 rows\n. . imported "SYS"."DATAPUMP$SQLOBJ$AUXDATA" 0 KB 0 rows\n. . imported "SYS"."DATAPUMP$SQLOBJ$DATA" 0 KB 0 rows\n. . imported "SYS"."DATAPUMP$SQLOBJ$PLAN" 0 KB 0 rows\n. . imported "SYS"."DATAPUMP$SQLOBJ$" 0 KB 0 rows\n. . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 0 KB 0 rows\n. . imported "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP" 0 KB 0 rows\n. . imported "WMSYS"."E$EXP_MAP" 7.718 KB 3 rows\n. . imported "WMSYS"."E$METADATA_MAP" 0 KB 0 rows\nProcessing object type DATABASE_EXPORT\/NORMAL_POST_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE_DATA\n. . imported "SYSTEM"."SYS_EXPORT_FULL_01" 0 KB 0 rows\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/COMMENT\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/STATISTICS\/TABLE_STATISTICS\nProcessing object type DATABASE_EXPORT\/STATISTICS\/MARKER\nProcessing object type DATABASE_EXPORT\/END_PLUGTS_BLK\nProcessing object type DATABASE_EXPORT\/FINAL_POST_INSTANCE_IMPCALLOUT\/MARKER\nProcessing object type DATABASE_EXPORT\/AUDIT_UNIFIED\/AUDIT_POLICY_ENABLE\nProcessing object type DATABASE_EXPORT\/POST_SYSTEM_IMPCALLOUT\/MARKER\nJob "SYSTEM"."SYS_IMPORT_FULL_01" completed with 7 error(s) at Mon Nov 30 15:46:56 2020 elapsed 0 00:01:35<\/code><\/pre>\n5\u3001\u9a8c\u8bc1\uff1a<\/h2>\n[oracle@cat1 ~]$ sqlplus test\/test@PDB2_WHS\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Mon Nov 30 15:49:05 2020\nVersion 19.3.0.0.0\n\nCopyright (c) 1982, 2019, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n\nSQL> select count(*) from test1;\n\n COUNT(*)\n----------\n 2178\n\nSQL> <\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"1\u3001\u521b\u5efa\u6d4b\u8bd5\u6570\u636e \u767b\u5f55non-CDB\uff0c\u521b\u5efa\u6570\u636e [<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-354","post","type-post","status-publish","format-standard","hentry","category-oracle-12c"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/354","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=354"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/354\/revisions"}],"predecessor-version":[{"id":1257,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/354\/revisions\/1257"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=354"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}