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: is based on Oracle Sample Schemas.
https://github.com/oracle-samples/db-sample-schemas
Complex Database: is 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
We can download the script here if you want to take a look.