Full Transportable Export/Import experiment_dingdingfish’s blog

class=”markdown_views prism-atom-one-dark”> A brief description of the environment Two instances, the source library is non-CDB, and the target is CDB. Both versions are 19.3. on the same host. Experiment to migrate non-CDB to PDB in CDB: hr_pdb Experimental process Make sure the platform and endianness are the same: SELECT d.PLATFORM_NAME,ENDIAN_FORMAT FROM V$TRANSPORTABLE_PLATFORM tp, V$DATABASE d WHERE tp.PLATFORM_ID = d.PLATFORM_ID; PLATFORM_NAMEENDIAN_FORMAT ——————– ————– Linux x86 64-bit Little Confirm that the tablespace is self-contained: ORCLCDB2 EXECUTE DBMS_TTS.TRANSPORT_SET_CHECK(‘users’, TRUE); PL/SQL procedure successfully completed. ORCCCDB2 SELECT * FROM TRANSPORT_SET_VIOLATIONS; no rows selected Create Directory: ORCLCDB2 CREATE DIRECTORY dp_dir AS ‘/u01/app/datafiles’ ; Directory created. Make the tablespace read-only: ORCLCDB2 ALTER TABLESPACE users READ ONLY; Tablespace altered. Enable full transportable tablespace export, if the source database is 11gR2, you also need to specify the VERSION=12 parameter: expdp system/Welcome1 full=y transportable=always \ directory=dp_dir dumpfile=full_tts.dmp \ metrics=y exclude=statistics \ logfile=full_tts_export.log Export: Release 19.0.0.0.0 – Production on Sat Oct 26 20:39:56 2019 Version 19.3.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 directory=dp_dir dumpfile=full_tts.dmp metrics=y exclude=statistics logfile=full_tts_export.log W-1 Startup took 1 second W-1 Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA W-1 Processing object…