0 Comments

Pluggable Database (PDB) Migration & Upgrade from 12c to 19c using Full Transportable Tablespace Export-Import 0 (0)

Pluggable Database (PDB) Migration & Upgrade from 12c to 19c using Full Transportable Tablespace Export-Import There are many ways to migrate PDB like Remote Clone, Unplug – Plug, RMAN. Here we will explore Full transportable tablespace export/import method that is fast and efficient. We will be migrating a pluggable database (TESTHIST) running on Oracle 12C […]

Loading

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

Loading

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

Loading

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

Loading

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

Loading

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

Loading

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

Loading