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