Friday, May 10, 2024

How to Export Pluggable database specific user or schema

 C:\export--directory name,manually build in a folder as your wish.

go to cmd as administrator mode.

connect to sys

alter session set container=orclpdb;

create directory exp_schema as 'C:\export';

GRANT read,write on DIRECTORY exp_schema TO SAMITY;

GRANT DATAPUMP_EXP_FULL_DATABASE TO samity;

expdp samity/samity@//107.167.94.211:1521/orclpdb DIRECTORY=exp_schema DUMPFILE=samitydb110524.dmp LOGFILE=samity_lg.log SCHEMAS=samity


No comments:

Post a Comment