Importing a dump file in Oracle 12C
Database Version: Oracle 12c To start with, Create a pluggable(container) before you import your data. (You have to be logged in to your database) eg. sqlplus sys as sysdba Step 1: Use the command below to create pluggable CREATE PLUGGABLE DATABASE <your_container_name> ADMIN USER PDB_ADMIN IDENTIFIED BY oracle FILE_NAME_CONVERT = ('/oradata/orcl/pdbseed/','/oradata/orcl/ <your_container_name> '); Note: username oracle in this case is the admin user for your database that you configured during installation. Step 2: Run these commands in order: alter session set container=<your_container_name>; startup; execute this on a new terminal tab to create pdb folder manually: mkdir -p /oradata/orcl/<your_container_name> Step 3: Execute the following 7 commands inside your container in their order: 01. CREATE OR REPLACE DIRECTORY PLUGGABLE_DATA_PUMP_DIR as '/oradata/orcl/<your_container_name>'; 02. GRANT REA...
Comments
Post a Comment