Here is the simple command to run expdp (data pump export) as sysdba. expdp “/as sysdba” parfile=exp_user.par
Here is the simple command to run oracle logical backup/datapump export using sysdba: expdp “/as sysdba” parfile=exp_user.par
Use the following procedure to take the consistent backup using expdp (oracle’s datapump export utility) Stop application activity(transactions) against database. This will ensure you that you don’t loose any transactions . 1. Make sure there are no pending transactions by running the following SQL: SQL> select count(*) from v$transaction; Above query should return with zero […]