Create a Custom Database Schema

Create a custom database schema in Oracle Autonomous AI Lakehouse associated with your Oracle Fusion Data Intelligence instance.

Note:

When you define your custom schema, make sure the custom schema name remains consistent across all environments. Avoid including environment-specific tags such as "TEST," "DEV," or "PROD". Inconsistent custom schema naming will prevent the deployment of your semantic model to other instances that use a different schema name.

While importing the objects, create a physical schema for the custom schema and import the objects into this physical schema. See Manage User Roles and Privileges on Autonomous Database and Create Users on Autonomous Database to create a custom database schema.

1. Connect to the Autonomous AI Lakehouse corresponding to your Oracle Fusion Data Intelligence instance.
   See Connect to an Autonomous AI Lakehouse.
2. Create a custom schema to store the customization data.

   Syntax: create user <custom_schema-name> identified by <custom_schema-password>;

   For example, create user example_schema identified by abcDEF123654;

   Note:

   Don't use any of these system-reserved terms as postfix in the custom schema names: DW, OAC, INFRA, SECURITY, USER, or CORE.