Fusion Analytics Autonomous database series: Understanding the default schema's provided

Abhishek Bajpai - CEAL Team-Oracle

Oracle Fusion Analytics Warehouse provides default schemas (also known as users) such as the ADMIN schema and OAX_USER schema.

You can create custom schemas to meet your customization requirements. The ADMIN schema enables you to access the Oracle Autonomous Data Warehouse instance associated with your Oracle Fusion Analytics Warehouse instance. The OAX_USER schema enables you to run your own SQL queries against the database or sign in and view the data in the tables of the associated Oracle Autonomous Data Warehouse instance. Initially, the password for these default schemas is the same. However, because of the Oracle Autonomous Data Warehouse security policy, the default and custom schemas' passwords expire every 365 days. You must change the password every year.

The video post covers introduction to the default schema

This video is a part of six-part series

1- Autonomous Datawarehouse- Connecting via SQL developer

2- Autonomous Datawarehouse- Schema Exploration

3- Autonomous Datawarehouse -Using Custom Schema

4- Exploring Autonomous Data Warehouse (ADW)

5- Exploring Autonomous Data Warehouse- Performance Telemetry

6- Exploring Data loads with Autonomous Data Warehouse