-- Full export datapump
create or replace directory EXP_DIR as 'F:\Oracle_Backup\export\MIMSYQC';
expdp '/ as sysdba' DUMPFILE=EXP_DIR:MIMSYQC_full.dpdmp LOGFILE=EXP_DIR:MIMSYQC_full_expdp.log FULL=Y

-- Schema export datapump
create or replace directory EXP_DIR as 'F:\Oracle_Backup\export\MIMSYQC';
expdp '/ as sysdba' schemas=SCOTT DUMPFILE=EXP_DIR:SCOTT_schema.dpdmp LOGFILE=EXP_DIR:SCOTT_schema_expdp.log