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
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: 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.