100% working EXPDP for Oracle database for exporting data from old database.

Check current directory pathes which are on the source database.

SELECT directory_name, directory_path

FROM dba_directories;

create and grant permision to run expdp for the same location which you want to run the backup.

CREATE OR REPLACE DIRECTORY DUMP_NEW_DIR AS '/BACKUP';

GRANT READ, WRITE ON DIRECTORY DUMP_NEW_DIR TO SYSTEM;

before running the below command create a file in the directory and give permissions as follows,

chmod -R 777 export.par

vi export.par

DIRECTORY=DUMP_NEW_DIR

DUMPFILE=full_db_export_%U.dmp

LOGFILE=export.log

FULL=Y

PARALLEL=2

run the command nohup to run this expdp without enteruptions.

nohup expdp system/oracle123 parfile=export.par &

check if any exp process are running on the database using below sql command.

col owner_name format a12

col job_name format a25

col state format a15

col operation format a10

col job_mode format a12

select owner_name,

job_name,

operation,

job_mode,

state

from dba_datapump_jobs

where operation = 'EXPORT'

order by job_name;

for more support and guidance feel free to reach out to me on whatsapp +94722222322

Oracle DBA - DATABASE