Export from a Non-CDB and Import in PDB

Introduction of Multitenant Architecture A logical backup taken from NON-CDB database can be easily imported into a pluggable database without any overhead. Let us see the example : Step 1: Check the database status SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB ——— ——————– — NCDB READ WRITE NO SQL> Step 2 : Create the […]

Read More

Export and Import Database link in Oracle 18c

In this post, we will export and import the database link with data pump in Oracle 18c. In next post, we will demonstrate to prevent the passwords of database link using keystores. First, we created the user for testing purpose. [oracle@18c OPatch]$ sqlplus system/sys@pdb18c2 SQL*Plus: Release 18.0.0.0.0 – Production on Wed May 30 10:12:42 2018 […]

Read More