Category: DATAPUMP
How To Recover Table from Drop/Truncate/Delete done on Primary using Flashback on a Standby
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 […]
431 total views, 2 views today
How to find Privileges on Directory in Oracle
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 […]
152 total views
Schema Refresh Using EXPDP-IMPDP command
Step by Step guide for Schema 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 schema refresh activity using Datapump: PARAMETERS SOURCE TARGET DATABASE […]
962 total views, 2 views today
Recent Comments