Wednesday, October 18, 2023

How to Import database on PLUGGABLE DATABASE

 cmd>sqlplus /nolog

conn sys as sysdba

alter session set container = ORCLPDB;

column name format a15;

alter pluggable database open;

alter pluggable database ORCLPDB save state;

create user oriondb identified by o;

grant connect,resource,dba to oriondb;

conn oriondb/o@//localhost:1521/ORCLPDB

Now take another CMD and run the command.

imp file=D:\ph.dmp log=D:\bkpdump\Saturday.log full=y;

USERNAME:oriondb/o@//localhost:1521/ORCLPDB

No comments:

Post a Comment