Revert a Pluggable Database to a non-CDB Database

As most folks in Oracle DBA world, Oracle has deprecated non-CDB since version 12c and, from Oracle 21c, this feature has been desupported, meaning that you can't create non-CDB DBs using Oracle DBCA.

However, there are vendors -- big, HAL-sized vendors -- that while requiring that their product use Oracle 19 LTS, refuse to even consider an installation on a CDB.

Why this prologue? Well, one day I was tasked to set up a spanking new Oracle 19c instance. I set it up, and duly created a CDB and an associated PDB. Tuned its parameters and imported the data.

So, imagine my face when, after setting up a proper CDB instance, importing data from a previous version using impdp and fixing the unescapable import errors, and spent hours supporting folks installing $BIG_CORPORATE_SOFTWARE I found that it didn't support PDBs (all while needing Oracle 19c no less).

What to do?

The Solution

Luckily, I found out that the Full Transportable Export-Import procedure used to ease migration from Non-CDB to CDB also works nicely when you want to revert from CDB to Non-CDB. And regarding my own special situation, the upgrade was quite straightforward.

Some notes before continuing:

Like a lot of DBAs out there, I store environment variables needed by Oracle in a profile file. At minimum, these files contain: $ORACLE_BASE,$ORACLE_HOME, $ORACLE_SID, $DATA_DIR and if needed $PDB_NAME.

So, when you see something like

$ source .profile<SID>

This means that I'm setting the environment variables needed to operate on a given Oracle instance.

What I did:

On the same machine of the CDB Instance, I created a new, non-PDB instance using DBCA in its command-line form:

nohup dbca -silent -createDatabase                                             \
-templateName General_Purpose.dbc \
-gdbname ${ORACLE_SID} -sid ${ORACLE_SID} -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword [syspdw] \
-systemPassword [oracle_pwd] \
-createAsContainerDatabase false \
-databaseType MULTIPURPOSE \
-memoryMgmtType auto_sga \
-totalMemory 3072 \
-storageType FS \
-datafileDestination "${DATA_DIR}" \
-enableArchive false \
-redoLogFileSize 250 \
-useOMF true \
-emConfiguration NONE \
-ignorePreReqs &

I then logged into the CDB machine, set my PDB as the container and made its tablespaces read only

$ source .profileCDB

$ sqlplus / as sysdba


SQL*Plus: Release 19.0.0.0.0 - Production on Thu Dec 9 09:05:57 2021
Version 19.13.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL> alter session set container=<my_pdb>;

session altered.

SQL> ALTER TABLESPACE <TS01> READ ONLY;

Tablespace altered.

SQL> ALTER TABLESPACE <TS02> READ ONLY;

Tablespace altered.

[..]
SQL> ALTER TABLESPACE <TSLAST> READ ONLY;

Tablespace altered.

SQL> ALTER TABLESPACE USERS READ ONLY;

Tablespace altered.

SQL> CREATE DIRECTORY DUMP_DIR AS '/path/to/expdp/dumps'

EXIT;

Don't forget to put USERS readonly, or else expdp will complain because USERS is missing (there are workarounds)

Then I created a exp_parfile for exporting data (from oracle 19 to oracle 19, mind you)

USERID=system/@
VERSION=19
DIRECTORY=DUMP_DIR
FULL=Y
TRANSPORTABLE=ALWAYS
METRICS=Y
EXCLUDE=STATISTICS
LOGFILE=DUMP_2021_12_09.log
DUMPFILE=DUMP_2021_12_09.dmp

Lastly, I executed the export

$ expdp parfile=exp_parfile

Export: Release 19.0.0.0.0 - Production on Thu Dec 9 09:48:50 2021
Version 19.13.0.0.0

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

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/********@ full=y transportable=always VERSION=19 directory=DUMP_DIR dumpfile=DUMP_2021_12_09.dmp metrics=y exclude=statistics
W-1 Startup took 0 seconds
W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
W-1 Processing object type DATABASE_EXPORT/PLUGTS_FULL/FULL/PLUGTS_TABLESPACE
W-1 Completed PLUGTS_TABLESPACE objects in seconds
W-1 Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
W-1 Completed 1 PLUGTS_BLK objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
W-1 Completed 1 PLUGTS_BLK objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
W-1 Completed 1 MARKER objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
W-1 Completed 1 MARKER objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/TABLESPACE
W-1 Completed 8 TABLESPACE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/PROFILE
W-1 Completed 1 PROFILE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/USER
W-1 Completed 15 USER objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/ROLE
W-1 Completed 1 ROLE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/RADM_FPTM
W-1 Completed 1 RADM_FPTM objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
W-1 Completed 7 PROC_SYSTEM_GRANT objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
W-1 Completed 4 SYSTEM_GRANT objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
W-1 Completed 18 ROLE_GRANT objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
W-1 Completed 18 DEFAULT_ROLE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
W-1 Completed 14 ON_USER_GRANT objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
W-1 Completed 57 TABLESPACE_QUOTA objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/RESOURCE_COST
W-1 Completed 1 RESOURCE_COST objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
W-1 Completed 1 TRUSTED_DB_LINK objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
W-1 Completed 671 SEQUENCE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
W-1 Completed 3180 OBJECT_GRANT objects in 2 seconds
W-1 Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
W-1 Completed 2 DIRECTORY objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
W-1 Completed 3 OBJECT_GRANT objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
W-1 Completed 2 PROCACT_SYSTEM objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
W-1 Completed 23 PROCOBJ objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
W-1 Completed 2 PROCACT_SYSTEM objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
W-1 Completed 19 PROCACT_SCHEMA objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
W-1 Completed 1 TABLE objects in 6 seconds
W-1 Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
W-1 Completed 1 MARKER objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
W-1 Completed 63 TABLE objects in 35 seconds
W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
W-1 Completed 18 TABLE objects in 20 seconds
W-1 Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER
W-1 Completed 1 MARKER objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
W-1 Completed 1043 TABLE objects in 20 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
W-1 Completed 8864 OBJECT_GRANT objects in 6 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
W-1 Completed 1212 COMMENT objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/IDENTITY_COLUMN
W-1 Completed 2 IDENTITY_COLUMN objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
W-1 Completed 260 FUNCTION objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
W-1 Completed 798 OBJECT_GRANT objects in 2 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
W-1 Completed 9 PROCEDURE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
W-1 Completed 260 ALTER_FUNCTION objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
W-1 Completed 9 ALTER_PROCEDURE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
W-1 Completed 23 VIEW objects in 2 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
W-1 Completed 78 OBJECT_GRANT objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
W-1 Completed 4 COMMENT objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
W-1 Completed 1328 INDEX objects in 5 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
W-1 Completed 306 INDEX objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
W-1 Completed 930 CONSTRAINT objects in 6 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
W-1 Completed 1401 REF_CONSTRAINT objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
W-1 Completed 110 TRIGGER objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
W-1 Completed 1 MARKER objects in 1 seconds
W-1 Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
W-1 Completed 14 PROCACT_SCHEMA objects in 2 seconds
W-1 Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
W-1 Completed 2 AUDIT_POLICY_ENABLE objects in 0 seconds
W-1 Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
W-1 Completed 1 MARKER objects in 0 seconds
W-1 . . exported "SYS"."KU$_USER_MAPPING_VIEW" 6.312 KB 50 rows in 1 seconds using external_table
W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P221" 27.54 MB 17153 rows in 0 seconds using direct_path
W-1 . . exported "AUDSYS"."AUD$UNIFIED":"SYS_P456" 52.06 KB 3 rows in 0 seconds using direct_path
W-1 . . exported "SYSTEM"."REDO_DB" 25.59 KB 1 rows in 1 seconds using direct_path
W-1 . . exported "SYS"."AUD$" 26.33 KB 21 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$WORKSPACES_TABLE$" 12.10 KB 1 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$HINT_TABLE$" 9.984 KB 97 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$INSTALLATIONS" 6.960 KB 2 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."DAM_CONFIG_PARAM$" 6.531 KB 14 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_SUBPOL$" 6.328 KB 1 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$NEXTVER_TABLE$" 6.375 KB 1 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$PROPS" 6.234 KB 5 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$ENV_VARS$" 6.015 KB 3 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_PARAMETER$" 5.953 KB 1 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_POLICY$" 5.921 KB 1 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$EVENTS_INFO$" 5.812 KB 12 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$AUDIT_ACTIONS" 5.757 KB 8 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$DIP_EVENTS" 5.539 KB 2 rows in 0 seconds using direct_path
W-1 . . exported "AUDSYS"."AUD$UNIFIED":"AUD_UNIFIED_P0" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$AUDIT" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$COMPARTMENTS" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$DIP_DEBUG" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$GROUPS" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$LAB" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$LEVELS" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$POL" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$POLICY_ADMIN" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$POLS" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$POLT" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$PROFILE" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$PROFILES" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$PROG" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$SESSINFO" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$USER" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$USER_COMPARTMENTS" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$USER_GROUPS" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "LBACSYS"."OLS$USER_LEVELS" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."DAM_CLEANUP_EVENTS$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."DAM_CLEANUP_JOBS$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_ASSOCIATION$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_CONDITION$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_FEATURE_POLICY$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_PROTECTION$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_SENSITIVE_DATA$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_SENSITIVE_TYPE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYS"."TSDP_SOURCE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "SYSTEM"."REDO_LOG" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$CONSTRAINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$CONS_COLUMNS$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$LOCKROWS_INFO$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$MODIFIED_TABLES$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$NESTED_COLUMNS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$RIC_LOCKING_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$RIC_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$RIC_TRIGGERS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$UDTRIG_INFO$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$VERSION_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$VT_ERRORS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
W-1 . . exported "MDSYS"."RDF_PARAM$" 6.515 KB 3 rows in 1 seconds using external_table
W-1 . . exported "SYS"."AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows in 0 seconds using external_table
W-1 . . exported "SYS"."DBA_SENSITIVE_DATA" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."FGA_LOG$FOR_EXPORT" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."NACL$_ACE_EXP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."NACL$_HOST_EXP" 6.914 KB 1 rows in 0 seconds using external_table
W-1 . . exported "SYS"."NACL$_WALLET_EXP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."SQL$TEXT_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."SQL$_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."SQLOBJ$AUXDATA_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."SQLOBJ$DATA_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."SQLOBJ$PLAN_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYS"."SQLOBJ$_DATAPUMP" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYSTEM"."SCHEDULER_JOB_ARGS" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "SYSTEM"."SCHEDULER_PROGRAM_ARGS" 0 KB 0 rows in 0 seconds using external_table
W-1 . . exported "WMSYS"."WM$EXP_MAP" 7.718 KB 3 rows in 3 seconds using external_table
W-1 . . exported "WMSYS"."WM$METADATA_MAP" 0 KB 0 rows in 0 seconds using external_table
W-1 Completed 1 DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 1 seconds
W-1 Completed 65 DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA objects in 1 seconds
W-1 Completed 18 DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 6 seconds
W-1 Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
//DUMP_2021_12_09.dmp
******************************************************************************
[... datafile to be transported]
[...]
Datafiles required for transportable tablespace USERS:
/oradata//D1A02BD211874F5BE05343F5A8C0030E/datafile/o1_mf_users_jszf66m9_.dbf
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Thu Dec 9 09:52:56 2021 elapsed 0 00:04:05

You can see that at the end of the log you will find the datafile to be copied and/or utilized by the news instance.

Performing the Import

Let's create the imp_parfile first. The TRANSPORT_DATAFILES parameter must contain a comma separated list of all of the datafiles returned by expdp.

Since the new, non-CDB Oracle instance had been setup on the same machine, I didn't change their path. Should you copy/move the datafiles, don't forget to use their new path in the impdp parfile!

[oracle@sorapdb01 ~]$ cat imp_igi19_parfile
userid=system/oracle@IGI19
DIRECTORY=DUMP_DIR
DUMPFILE=DUMP_2021_12_09.dmp
LOGFILE=DUMP_2021_12_09.imp.log
METRICS=Y
LOGTIME=all
TRANSPORT_DATAFILES='/oradata//D1A02BD211874F5BE05343F5A8C0030E/datafile/o1_mf_file_01.dbf',
'/oradata//D1A02BD211874F5BE05343F5A8C0030E/datafile/o1_mf_file_02_.dbf',
[...]
'/oradata//D1A02BD211874F5BE05343F5A8C0030E/datafile/o1_mf_users_jszf66m9_.dbf'

Let's activate the Non-CDB database:

$ source .profileNONCDB

Let's connect to SQLplus and create the directory that contains the dumpfile:

$ sqlplus / as sysdba 

[....]

$ CREATE DIRECTORY DUMP_DIR as '/path/containing/dump/file';

Now, we're facing a problem: since we exported the USERS tablespace, our impdp run will probably fail because it will find the USERS tablespace already in place, even if our instance is brand spaking new and there are no schemas on USERS. Moreover, if we try to drop the USERS tablespace, Oracle will complain because DBCA sets it as its default tablespace.

Easy:

  1. Create a new tablespace
  2. Make it the default database-wide tablespace
  3. Drop TABLESPACE USERS INCLUDING CONTENTS AND DATAFILES;

This translates into:

SQL> CREATE TABLESPACE NONCDB_DEF_TS;
SQL> alter database default tablespace NONCDB_DEF_TS;
sql> Drop TABLESPACE USERS INCLUDING CONTENTS AND DATAFILES

After having done that, you can perform the import in your new, non-CDB instance.

$ impdp parfile=imp_noncdb_parfile

Import: Release 19.0.0.0.0 - Production on Thu Dec 9 10:06:47 2021
Version 19.13.0.0.0

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

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
09-DEC-21 10:06:48.344: W-1 Startup took 0 seconds
09-DEC-21 10:06:48.859: W-1 Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
09-DEC-21 10:06:49.508: Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/********@ parfile=imp_noncdb_parfile
09-DEC-21 10:06:49.591: W-1 Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
09-DEC-21 10:06:50.126: W-1 Completed 1 MARKER objects in 1 seconds
09-DEC-21 10:06:50.126: W-1 Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
09-DEC-21 10:06:50.917: W-1 Completed 1 MARKER objects in 0 seconds
09-DEC-21 10:06:50.917: W-1 Processing object type DATABASE_EXPORT/PLUGTS_FULL/PLUGTS_BLK
09-DEC-21 10:06:51.403: W-1 Completed 1 PLUGTS_BLK objects in 0 seconds
09-DEC-21 10:06:51.403: W-1 Processing object type DATABASE_EXPORT/TABLESPACE
09-DEC-21 10:06:51.638: ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
09-DEC-21 10:06:51.638: ORA-31684: Object type TABLESPACE:"TEMP" already exists
09-DEC-21 10:06:51.757: W-1 Completed 8 TABLESPACE objects in 0 seconds
09-DEC-21 10:06:51.757: W-1 Processing object type DATABASE_EXPORT/PROFILE
09-DEC-21 10:06:51.977: W-1 Completed 1 PROFILE objects in 0 seconds
09-DEC-21 10:06:51.977: W-1 Processing object type DATABASE_EXPORT/SCHEMA/USER
09-DEC-21 10:06:52.380: W-1 Completed 15 USER objects in 0 seconds
09-DEC-21 10:06:52.380: W-1 Processing object type DATABASE_EXPORT/ROLE
09-DEC-21 10:06:52.603: W-1 Completed 1 ROLE objects in 0 seconds
09-DEC-21 10:06:52.603: W-1 Processing object type DATABASE_EXPORT/RADM_FPTM
09-DEC-21 10:06:52.814: W-1 Completed 1 RADM_FPTM objects in 0 seconds
09-DEC-21 10:06:52.814: W-1 Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
09-DEC-21 10:06:55.911: W-1 Completed 7 PROC_SYSTEM_GRANT objects in 3 seconds
09-DEC-21 10:06:55.911: W-1 Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
09-DEC-21 10:06:56.109: W-1 Completed 4 SYSTEM_GRANT objects in 1 seconds
09-DEC-21 10:06:56.109: W-1 Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
09-DEC-21 10:06:56.347: W-1 Completed 18 ROLE_GRANT objects in 0 seconds
09-DEC-21 10:06:56.347: W-1 Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
09-DEC-21 10:06:56.574: W-1 Completed 18 DEFAULT_ROLE objects in 0 seconds
09-DEC-21 10:06:56.574: W-1 Processing object type DATABASE_EXPORT/SCHEMA/ON_USER_GRANT
09-DEC-21 10:06:56.814: W-1 Completed 14 ON_USER_GRANT objects in 0 seconds
09-DEC-21 10:06:56.814: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA
09-DEC-21 10:06:57.242: W-1 Completed 57 TABLESPACE_QUOTA objects in 1 seconds
09-DEC-21 10:06:57.242: W-1 Processing object type DATABASE_EXPORT/RESOURCE_COST
09-DEC-21 10:06:57.448: W-1 Completed 1 RESOURCE_COST objects in 0 seconds
09-DEC-21 10:06:57.448: W-1 Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
09-DEC-21 10:06:57.655: W-1 Completed 1 TRUSTED_DB_LINK objects in 0 seconds
09-DEC-21 10:06:57.655: W-1 Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
09-DEC-21 10:06:58.909: W-1 Completed 671 SEQUENCE objects in 1 seconds
09-DEC-21 10:06:58.909: W-1 Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
09-DEC-21 10:07:03.127: W-1 Completed 3180 OBJECT_GRANT objects in 4 seconds
09-DEC-21 10:07:03.127: W-1 Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
09-DEC-21 10:07:03.341: W-1 Completed 2 DIRECTORY objects in 0 seconds
09-DEC-21 10:07:03.341: W-1 Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
09-DEC-21 10:07:03.546: W-1 Completed 3 OBJECT_GRANT objects in 0 seconds
09-DEC-21 10:07:03.546: W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
09-DEC-21 10:07:03.813: W-1 Completed 2 PROCACT_SYSTEM objects in 0 seconds
09-DEC-21 10:07:03.813: W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
09-DEC-21 10:07:04.289: W-1 Completed 23 PROCOBJ objects in 1 seconds
09-DEC-21 10:07:04.289: W-1 Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
09-DEC-21 10:07:29.763: W-1 Completed 2 PROCACT_SYSTEM objects in 25 seconds
09-DEC-21 10:07:29.763: W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
09-DEC-21 10:07:29.995: W-1 Completed 19 PROCACT_SCHEMA objects in 0 seconds
09-DEC-21 10:07:29.995: W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE
09-DEC-21 10:07:30.349: W-1 Completed 1 TABLE objects in 0 seconds
09-DEC-21 10:07:30.428: W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
09-DEC-21 10:07:30.750: W-1 . . imported "SYS"."KU$_EXPORT_USER_MAP" 6.312 KB 50 rows in 0 seconds using direct_path
09-DEC-21 10:07:30.843: W-1 Processing object type DATABASE_EXPORT/EARLY_POST_INSTANCE_IMPCALLOUT/MARKER
09-DEC-21 10:07:31.041: W-1 Completed 1 MARKER objects in 0 seconds
09-DEC-21 10:07:31.041: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE
09-DEC-21 10:07:34.300: W-1 Completed 52 TABLE objects in 3 seconds
09-DEC-21 10:07:34.360: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
09-DEC-21 10:07:34.483: W-1 . . imported "SYS"."DP$TSDP_SUBPOL$" 6.328 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.485: W-1 . . imported "SYSTEM"."REDO_LOG_TMP" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.512: W-1 . . imported "WMSYS"."E$VERSION_HIERARCHY_TABLE$" 5.984 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.512: W-1 . . imported "LBACSYS"."OLS_DP$OLS$COMPARTMENTS" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.513: W-1 . . imported "SYS"."AMGT$DP$DAM_CLEANUP_JOBS$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.535: W-1 . . imported "SYS"."DP$TSDP_PARAMETER$" 5.953 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.536: W-1 . . imported "SYS"."DP$TSDP_SENSITIVE_TYPE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.556: W-1 . . imported "WMSYS"."E$WORKSPACE_PRIV_TABLE$" 7.078 KB 11 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.557: W-1 . . imported "LBACSYS"."OLS_DP$OLS$GROUPS" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.558: W-1 . . imported "LBACSYS"."OLS_DP$OLS$POL" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.590: W-1 . . imported "SYS"."AMGT$DP$AUD$" 26.33 KB 21 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.591: W-1 . . imported "SYS"."DP$TSDP_SENSITIVE_DATA$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.592: W-1 . . imported "WMSYS"."E$BATCH_COMPRESSIBLE_TABLES$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.593: W-1 . . imported "LBACSYS"."OLS_DP$OLS$PROG" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.594: W-1 . . imported "SYS"."DP$TSDP_PROTECTION$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.616: W-1 . . imported "WMSYS"."E$NEXTVER_TABLE$" 6.375 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.617: W-1 . . imported "WMSYS"."E$RESOLVE_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.617: W-1 . . imported "WMSYS"."E$RIC_TRIGGERS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.618: W-1 . . imported "WMSYS"."E$UDTRIG_DISPATCH_PROCS$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.619: W-1 . . imported "WMSYS"."E$MP_GRAPH_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.620: W-1 . . imported "WMSYS"."E$MP_PARENT_WORKSPACES_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.642: W-1 . . imported "WMSYS"."E$WORKSPACES_TABLE$" 12.10 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.642: W-1 . . imported "LBACSYS"."OLS_DP$OLS$POLS" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.643: W-1 . . imported "SYS"."AMGT$DP$DAM_CLEANUP_EVENTS$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.644: W-1 . . imported "WMSYS"."E$NESTED_COLUMNS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.645: W-1 . . imported "WMSYS"."E$RIC_LOCKING_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.646: W-1 . . imported "WMSYS"."E$VERSION_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.647: W-1 . . imported "WMSYS"."E$WORKSPACE_SAVEPOINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.647: W-1 . . imported "LBACSYS"."OLS_DP$OLS$AUDIT" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.648: W-1 . . imported "LBACSYS"."OLS_DP$OLS$LAB" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.672: W-1 . . imported "SYS"."AMGT$DP$DAM_CONFIG_PARAM$" 6.531 KB 14 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.693: W-1 . . imported "SYS"."DP$TSDP_POLICY$" 5.921 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.694: W-1 . . imported "WMSYS"."E$RIC_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.715: W-1 . . imported "WMSYS"."E$ENV_VARS$" 6.015 KB 3 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.737: W-1 . . imported "WMSYS"."E$EVENTS_INFO$" 5.812 KB 12 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.762: W-1 . . imported "SYSTEM"."REDO_DB_TMP" 25.59 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.763: W-1 . . imported "SYS"."DP$TSDP_ASSOCIATION$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.764: W-1 . . imported "SYS"."DP$TSDP_FEATURE_POLICY$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.765: W-1 . . imported "WMSYS"."E$UDTRIG_INFO$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.766: W-1 . . imported "WMSYS"."E$CONSTRAINTS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.766: W-1 . . imported "WMSYS"."E$LOCKROWS_INFO$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.767: W-1 . . imported "WMSYS"."E$MODIFIED_TABLES$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.768: W-1 . . imported "WMSYS"."E$VT_ERRORS_TABLE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.769: W-1 . . imported "LBACSYS"."OLS_DP$OLS$USER" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.770: W-1 . . imported "SYS"."DP$TSDP_SOURCE$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.770: W-1 . . imported "SYS"."DP$TSDP_CONDITION$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.771: W-1 . . imported "WMSYS"."E$CONS_COLUMNS$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.790: W-1 . . imported "WMSYS"."E$HINT_TABLE$" 9.984 KB 97 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.792: W-1 . . imported "LBACSYS"."OLS_DP$OLS$POLT" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.793: W-1 . . imported "LBACSYS"."OLS_DP$OLS$PROFILE" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:34.794: W-1 . . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"AUD_UNIFIED_P0" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:35.614: W-1 . . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"SYS_P221" 27.54 MB 17153 rows in 1 seconds using direct_path
09-DEC-21 10:07:35.691: W-1 . . imported "AUDSYS"."AMGT$DP$AUD$UNIFIED":"SYS_P456" 52.06 KB 3 rows in 0 seconds using direct_path
09-DEC-21 10:07:35.692: W-1 . . imported "LBACSYS"."OLS_DP$OLS$LEVELS" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:35.780: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE
09-DEC-21 10:07:37.067: W-1 Completed 18 TABLE objects in 1 seconds
09-DEC-21 10:07:37.130: W-1 Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
09-DEC-21 10:07:37.235: W-1 . . imported "SYS"."NACL$_HOST_IMP" 6.914 KB 1 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.279: W-1 . . imported "MDSYS"."RDF_PARAM$TBL" 6.515 KB 3 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.281: W-1 . . imported "SYS"."DP$DBA_SENSITIVE_DATA" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.283: W-1 . . imported "SYSTEM"."SCHEDULER_PROGRAM_ARGS_TMP" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.285: W-1 . . imported "WMSYS"."E$METADATA_MAP" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.287: W-1 . . imported "SYS"."AMGT$DP$FGA_LOG$FOR_EXPORT" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.288: W-1 . . imported "SYS"."DP$DBA_TSDP_POLICY_PROTECTION" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.305: W-1 . . imported "SYS"."AMGT$DP$AUDTAB$TBS$FOR_EXPORT" 5.953 KB 2 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.306: W-1 . . imported "SYS"."DATAPUMP$SQL$TEXT" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.307: W-1 . . imported "SYS"."DATAPUMP$SQLOBJ$AUXDATA" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.308: W-1 . . imported "SYS"."NACL$_WALLET_IMP" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.308: W-1 . . imported "SYS"."DATAPUMP$SQL$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.309: W-1 . . imported "SYS"."DATAPUMP$SQLOBJ$PLAN" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.310: W-1 . . imported "SYS"."DATAPUMP$SQLOBJ$DATA" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.339: W-1 . . imported "WMSYS"."E$EXP_MAP" 7.718 KB 3 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.341: W-1 . . imported "SYS"."DATAPUMP$SQLOBJ$" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.343: W-1 . . imported "SYSTEM"."SCHEDULER_JOB_ARGS_TMP" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.344: W-1 . . imported "SYS"."NACL$_ACE_IMP" 0 KB 0 rows in 0 seconds using direct_path
09-DEC-21 10:07:37.428: W-1 Processing object type DATABASE_EXPORT/NORMAL_POST_INSTANCE_IMPCALLOUT/MARKER
09-DEC-21 10:07:38.537: W-1 Completed 1 MARKER objects in 1 seconds
09-DEC-21 10:07:38.537: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
09-DEC-21 10:08:25.630: W-1 Completed 1043 TABLE objects in 47 seconds
09-DEC-21 10:08:25.630: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
09-DEC-21 10:08:36.646: W-1 Completed 8864 OBJECT_GRANT objects in 11 seconds
09-DEC-21 10:08:36.646: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/COMMENT
09-DEC-21 10:08:38.021: W-1 Completed 1212 COMMENT objects in 1 seconds
09-DEC-21 10:08:38.021: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/IDENTITY_COLUMN
09-DEC-21 10:08:38.575: W-1 Completed 2 IDENTITY_COLUMN objects in 0 seconds
09-DEC-21 10:08:38.575: W-1 Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
09-DEC-21 10:08:40.091: W-1 Completed 260 FUNCTION objects in 1 seconds
09-DEC-21 10:08:40.091: W-1 Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
09-DEC-21 10:08:41.223: W-1 Completed 798 OBJECT_GRANT objects in 1 seconds
09-DEC-21 10:08:41.223: W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
09-DEC-21 10:08:41.474: W-1 Completed 9 PROCEDURE objects in 0 seconds
09-DEC-21 10:08:41.474: W-1 Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
09-DEC-21 10:08:45.846: W-1 Completed 260 ALTER_FUNCTION objects in 4 seconds
09-DEC-21 10:08:45.846: W-1 Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
09-DEC-21 10:08:46.234: W-1 Completed 9 ALTER_PROCEDURE objects in 1 seconds
09-DEC-21 10:08:46.234: W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/VIEW
09-DEC-21 10:08:46.665: W-1 Completed 23 VIEW objects in 0 seconds
09-DEC-21 10:08:46.665: W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
09-DEC-21 10:08:46.999: W-1 Completed 78 OBJECT_GRANT objects in 0 seconds
09-DEC-21 10:08:46.999: W-1 Processing object type DATABASE_EXPORT/SCHEMA/VIEW/COMMENT
09-DEC-21 10:08:47.232: W-1 Completed 4 COMMENT objects in 0 seconds
09-DEC-21 10:08:47.424: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
09-DEC-21 10:09:06.637: W-1 Completed 1328 INDEX objects in 19 seconds
09-DEC-21 10:09:06.637: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
09-DEC-21 10:09:11.732: W-1 Completed 306 INDEX objects in 5 seconds
09-DEC-21 10:09:11.732: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
09-DEC-21 10:09:20.366: W-1 Completed 930 CONSTRAINT objects in 9 seconds
09-DEC-21 10:09:20.366: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/REF_CONSTRAINT
09-DEC-21 10:09:28.083: W-1 Completed 1401 REF_CONSTRAINT objects in 7 seconds
09-DEC-21 10:09:28.083: W-1 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TRIGGER
09-DEC-21 10:09:31.331: W-1 Completed 110 TRIGGER objects in 3 seconds
09-DEC-21 10:09:31.331: W-1 Processing object type DATABASE_EXPORT/END_PLUGTS_BLK
09-DEC-21 10:09:31.657: W-1 Completed 1 PLUGTS_BLK objects in 0 seconds
09-DEC-21 10:09:31.657: W-1 Processing object type DATABASE_EXPORT/FINAL_POST_INSTANCE_IMPCALLOUT/MARKER
09-DEC-21 10:09:35.859: W-1 Completed 1 MARKER objects in 4 seconds
09-DEC-21 10:09:35.859: W-1 Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
09-DEC-21 10:09:36.114: W-1 Completed 14 PROCACT_SCHEMA objects in 1 seconds
09-DEC-21 10:09:36.114: W-1 Processing object type DATABASE_EXPORT/AUDIT_UNIFIED/AUDIT_POLICY_ENABLE
09-DEC-21 10:09:36.347: W-1 Completed 2 AUDIT_POLICY_ENABLE objects in 0 seconds
09-DEC-21 10:09:36.347: W-1 Processing object type DATABASE_EXPORT/POST_SYSTEM_IMPCALLOUT/MARKER
09-DEC-21 10:09:38.113: W-1 Completed 1 MARKER objects in 1 seconds
09-DEC-21 10:09:38.231: W-1 Completed 1 DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 0 seconds
09-DEC-21 10:09:38.232: W-1 Completed 65 DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA objects in 892 seconds
09-DEC-21 10:09:38.233: W-1 Completed 18 DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA objects in 0 seconds
09-DEC-21 10:09:38.450: Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" completed with 49 error(s) at Thu Dec 9 10:09:38 2021 elapsed 0 00:02:51