Skip to main content

Posts

Showing posts from April, 2026

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...