Category: DATAPUMP
Table Refresh Using EXPDP-IMPDP Datapump Command
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
Full Database Refresh Using EXPDP-IMPDP Datapump command
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 […]
617 Total Views, 2 Views Today
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 […]
1,184 Total Views
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 […]
318 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 […]
1,349 Total Views, 3 Views Today
Recent Comments