0 Comments

Table Refresh Using EXPDP-IMPDP Datapump Command 0 (0)

Step by Step guide for Table Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Requirement of Table refresh: Table refresh is a common task that is quite often […]

 281 Total Views

2 Comments

Full Database Refresh Using EXPDP-IMPDP Datapump command 5 (4)

Step by Step guide for Full Database Refresh using DataPump Utility Oracle Data Pump is a high-speed data movement utility provided by Oracle (10g onwards). It’s an extension to the old EXP and IMP utility with improved performance and enhanced security features. Here we are performing a full database refresh activity using Datapump: PARAMETERS SOURCE […]

 616 Total Views,  1 Views Today

0 Comments

How To Recover Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby 5 (3)

Recover a Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby In this article, we will learn steps needed to perform recovery of User wrong operation like delete/drop/truncate action on the production table without using Restore and Recover command on PRIMARY DATABASE.Recovering the table from the standby database will also eliminate any required […]

 1,184 Total Views

0 Comments

Solution for Error ORA-29289 Directory Access Denied in Oracle 5 (1)

Error ORA-29289 Directory Access Denied in Oracle Sometimes application users have DIRECTORY details like name of DIRECTORY of a database but not having proper privileges (READ, WRITE) on DIRECTORY and received error “ORA-29289″ directory access denied”. Thanks to one of my application users who did the same mistake yesterday and encourage to me elaborate here […]

 850 Total Views

2 Comments

How to find Privileges on Directory in Oracle 5 (1)

Find Privileges on Directory in Oracle Oracle has introduced the concept of DIRECTORY which is a type of object and introduced in Oracle version 8.0. DIRECTORY is a logical structure that presents a physical directory on the database server’s file system.DIRECTORY  can be used in DATAPUMP, PL/SQL block, UTL_FILE packages, etc In Oracle. Below is […]

 318 Total Views