Migrate or Create Database Objects

Migrate or create database objects such as tables, views, and synonyms in the custom schema that you created.

Import or migrate your external warehouse data to the Oracle Autonomous AI Lakehouse associated with Oracle Fusion Data Intelligence using the Oracle database utilities or any ETL tool.

1. Create one or more tables in the custom schema that you created.

   Syntax: CREATE TABLE <custom_schema-name>.<custom_extent_table_name> (<parameters>));

   Example: CREATE TABLE example_schema.ABC_EXTN ("DATE" DATE, "CATEGORY" VARCHAR2(1024 BYTE) , "MANAGER" VARCHAR2(1024 BYTE) );