Oracle Golden Gate Prerequisite Set up Part – 2

At Source:- 1.. Connecting to Pluggable Database PDBPROD 2… Creating user  in pluggable Database PDBPROD 3.. Grant resources and connect to user created 4.. Connect to user created in previous step i.e PDBPROD pluggable database and create two tables emp1 and dept1 5.. Now at Target: -   Connecting to Pluggable Database PDBDEV Create user  in … Continue reading Oracle Golden Gate Prerequisite Set up Part – 2

Querying files on the Oracle Cloud Infrastructure Object Storage (OCI) directly without loading them to your database aka querying Data in External Files

1.. Create External Tables with DBMS_CLOUD :- Connect with SQL Developer and use given below scripts to create external table. In this case we will use the create_external_table procedure of the DBMS_CLOUD package to create external tables on the files staged in object store. Given below credential are same as we did it for OCI_OBJECT_UPLOAD … Continue reading Querying files on the Oracle Cloud Infrastructure Object Storage (OCI) directly without loading them to your database aka querying Data in External Files

Loading Data into Your New Autonomous Data Warehouse Using Object Storage OCI and DBMS_CLOUD package

1.. Connect to SQL developer and create Target Tables for Data Loading. Total of 9 tables created by the scripts. 2.. Login to OCI console, select compartment appropriately 2.1  Give name for bucket as ADW_BUCK and leave rest as default or given below. 2.2 Now click on the bucket that you have created and browse … Continue reading Loading Data into Your New Autonomous Data Warehouse Using Object Storage OCI and DBMS_CLOUD package

Loading Data into Your New Autonomous Data Warehouse Using SQL*Loader

1.. Login to SQL developer 2.. Expand ADW_LOAD and Click ‘Tables’ in your user schema object tree. Clicking the right mouse button opens the context-sensitive menu in SQL Developer; select ‘Import Data’; 3.. Under the tab Preview:- The Data Import Wizard is started. 3.1.. Select Local File as source for the data load 3.2.. Click … Continue reading Loading Data into Your New Autonomous Data Warehouse Using SQL*Loader

Working with Data Warehouse Services and the Free Sample Data Sets

Autonomous Data Warehouse provides three database services that you can choose when connecting to Autonomous Warehouse database. These are named as HIGH, MEDIUM, and LOW services and provide different levels of performance and concurrency. High: The High database service provides the highest level of resources to each SQL statement resulting in the highest performance but … Continue reading Working with Data Warehouse Services and the Free Sample Data Sets

Provisioning a New Autonomous Data Warehouse in OCI

1.. Login to Oracle Cloud account Give the name of your Cloud Tenant and click continue 2.. Give username and password and click on tab sign in 3.. Once logged in you can navigate to reach panel to create Autonomous Warehouse Database in two ways either click on tab Autonomous Data Warehouse under the tab … Continue reading Provisioning a New Autonomous Data Warehouse in OCI

Oracle Golden Gate Prerequisite Set up Part – 1

Assumption :- At both source and target server. Oracle Database version 12cR1 and Oracle GoldenGate 12.2 is installed . At Source :- 1.. Connecting to Pluggable Database PDBPROD 2..  Creating user  in pluggable Database PDBPROD 3.. Grant resources and connect to user created 4.. Connect to user created in previous step i.e PDBPROD pluggable database … Continue reading Oracle Golden Gate Prerequisite Set up Part – 1

Installation of Oracle GoldenGate 12.2 for Oracle Database 12cR1 ….

Assumption: - At both source and target server. Oracle Database version 12cR1 is already installed prior to installation of Oracle GoldenGate 12.2 1.. unzip Oracle GoldenGate binaries 2.. Once unzipped, directory will be created as given below and go to this directory 3.. Now go to given below directory 4.. list out directory contents and … Continue reading Installation of Oracle GoldenGate 12.2 for Oracle Database 12cR1 ….