We are hosting a webinar series on migrating to Autonomous Database. You can find more details here.
In this series, we will use two databases.
Simple Database
Based on Oracle Sample Schemas:
https://github.com/oracle-samples/db-sample-schemas
Schemas to install:
HR: Human Resources
CO: Customer Orders
SH: Sales History
Scripts to Run:
- @hr_install.sql
- @co_install.sql
- @sh_install.sql
Complex Database
Based on Oracle Sample Schemas + manually created objects:
- External Tables
- Tables with encrypted columns
- Tables with XML columns
- Tables using Spatial
- Tables with ROWID columns
- Table Clusters
- Scheduler Jobs running external scripts
- Procedure calling DBMS_SHARED_POOL and UTL_HTTP
- External Library
- Java Objects
- XML Schemas
- Profiles using custom password verification functions
- SQL Patches and SQL Plan Baselines
- Jobs using DBMS_JOB
You can download the script here if you’d like to look into it.
You can check the CPAT reports for these sample databases here:
Using options: --targetcloud ATPS --migrationmethod DATAPUMP
Using options: --targetcloud ALL --migrationmethod ALL