Skip to main content

StreamShift Documentation

Oracle setup

Source setup

If the source and target are both Oracle and you are doing a "Lift and Shift only" migration, create a user for use by Striim and grant it SELECT privileges on all tables to be migrated.

In all other cases, set up the source as described in Basic Oracle configuration tasks, Creating an Oracle user with LogMiner privileges, and Creating the quiescemarker table. If your source database is PDB, also grant the Oracle user the ALTER SESSION privilege.

Target setup

  1. Create the target schema(s).

  2. Create a CHKPOINT table in one of the target schemas:

    CREATE TABLE CHKPOINT (
  ID VARCHAR2(100) PRIMARY KEY, 
  SOURCEPOSITION BLOB, 
  PENDINGDDL NUMBER(1), 
  DDL CLOB);

  3. Create a role and user for use by Striim as follows, replacing ******** with a strong password. You may use any role or user name you wish.

    CREATE ROLE STRIIM_PRIVS;
GRANT CREATE SESSION TO STRIIM_PRIVS;
GRANT CREATE USER TO STRIIM_PRIVS;
GRANT CREATE ANY TABLE TO STRIIM_PRIVS;
GRANT SELECT ANY TABLE TO STRIIM_PRIVS;
GRANT ALTER ANY TABLE TO STRIIM_PRIVS;
GRANT INSERT ANY TABLE TO STRIIM_PRIVS;
GRANT UPDATE ANY TABLE TO STRIIM_PRIVS;
GRANT DROP ANY TABLE TO STRIIM_PRIVS;
GRANT CREATE ANY INDEX TO STRIIM_PRIVS;
GRANT UNLIMITED TABLESPACE TO STRIIM_PRIVS WITH ADMIN OPTION;
GRANT SELECT_CATALOG_ROLE TO STRIIM_PRIVS;
CREATE USER STRIIM IDENTIFIED BY ******** DEFAULT TABLESPACE USERS;
GRANT STRIIM_PRIVS TO STRIIM;

    If the source is also Oracle, add these additional privileges:

    GRANT SELECT ANY DICTIONARY TO STRIIM_PRIVS;
GRANT DATAPUMP_IMP_FULL_DATABASE TO STRIIM_PRIVS;
GRANT EXECUTE ANY PROCEDURE TO STRIIM_PRIVS;
In this section: