Contact

Tag: expdp

  1. You are here »
  2. Home »
  3. Tag »
  4. expdp »

expdp as sysdba

Here is the simple command to run expdp (data pump export) as sysdba. expdp “/as sysdba” parfile=exp_user.par

expdp as sysdba

Here is the simple command to run oracle logical backup/datapump export using sysdba: expdp “/as sysdba” parfile=exp_user.par  

Oracle Database consistent backup using expdp

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 […]

Categories