17.1 Set the Prerequisites

Go through the prerequisites you need to set before you launch and use Oracle Data Transforms in an Compute Cloud@Customer environment.

Do the following:

1. Install Oracle RDBMS in the same compute instance or another instance in the same VCN network. Alternatively, you can use an existing DB.

   Note:

   Make sure that it is a non-container database.
2. Connect to the DB as sys.
3. Run the following command:

   alter session set "_ORACLE_SCRIPT"=true;

4. Run the following SQL commands to create the schema:

   Create user admin identified by Welcome_123#

   grant connect,resource,dba to admin;

   grant execute on dbms_lock to admin with grant option;

   grant execute on DBMS_DATAPUMP to admin with grant option;

   create tablespace DATA DATAFILE '/u02/app/data/<dbinstance>data02.dbf'

   SIZE 100M AUTOEXTEND ON;