CONTENUTI

1) Course Overview

• Describe the course objectives and prerequisites
• Explore the course road map & use case
• Identify course persona
• Course Prerequisites
• Identify the course environment and sample schema used in this course

 

2) Migrating Your Oracle Database to Autonomous Database Overview

• Oracle Autonomous Cloud Platform Overview
• Autonomous Database: Overview
• Autonomous Data Warehouse: Overview
• Autonomous Transaction Processing: Overview
• Migration: What, Why, and How

 

3) Analyzing and Choosing Your Migration Strategy

• Analyzing Source System: On-Premises Oracle Database
• Identifying Database Objects to be Migrated
• Identify the benefits of this migration
• Choosing a Migration Strategy

 

4) Preparing Source and Target Systems for Migration

• Prepare the source database for migration
• Create the target system: Autonomous Database instances
• Prepare the target service instances
• Create a storage bucket in Oracle Cloud Infrastructure Object Storage

 

5) Migrating Using SQL Developer

• Describe the methods and techniques to migrate database objects and segments by using SQL Developer
• Migrate tables by using SQL Developer
• Perform post-migration verification tasks

 

6) Migrating On-Premises Database Schema Using Data Pump

• Explore Data Pump migration methods
• Use Oracle Data Pump Export to export database schemas
• Upload Data Pump files to Oracle Cloud Infrastructure Object Storage
• Use Oracle Data Pump Import to import data files into Autonomous Data Warehouse