Sruti Banerjee January 26, 2021 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 […]

 1,948 Total Views,  7 Views Today

READ MORE
Sruti Banerjee January 26, 2021 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 […]

 3,964 Total Views,  7 Views Today

READ MORE
Jamsher Khan December 22, 2020 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 […]

 2,498 Total Views,  7 Views Today

READ MORE
DBsGuru November 27, 2020 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 […]

 1,892 Total Views,  2 Views Today

READ MORE
Sruti Banerjee November 6, 2020 2 Comments

Schema Refresh Using EXPDP-IMPDP command 5 (2)

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

 4,356 Total Views,  8 Views Today

READ MORE
DBsGuru September 4, 2020 6 Comments

DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE 4.7 (24)

DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER IN ORACLE In this article, we are going to demonstrate DATABASE MIGRATION FROM WINDOW SERVER TO LINUX SERVER. This is required as part of migration on request of the client to route application on new configuration (Weblogic). DATABASE DETAIL : Source: WINDOWS SERVER VERSION Windows Server 2012 R2 Standard […]

 3,024 Total Views

READ MORE