--
--  Allow 45 minutes for installation (depending on the size of the host)
-- 

--------------------------------------------------------
-- 
-- !!! log in as a user with DBA privilege (master user in RDS)
--
--------------------------------------------------------

-- Spool to output
spool install-rds.out


--------------------------------------------------------
--
-- The dms_sample user/schema contains the objects and data
-- for this database. 
--
-- The following script creates the user dms_sample/dms_sample
-- it is recommended that you change the password
-- after creating the account.
--
---------------------------------------------------------

@user/create_dms_sample.sql


---------------------------------------------------------
-- In order to capture changes supplemental logging is required
-- The following commands turn on supplemental logging and increase 
-- archive retention (RDS)
---------------------------------------------------------

---------------------------------------------------------
-- If your source is NOT on RDS:
---------------------------------------------------------
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;



--------------------------------------------------------
-- 
-- In general, it's a good idea to create and use an 
-- account other than the account that owns the schema 
-- objects for the migration. The following creates the 
-- user dms_user/dms_user which can be used to migrate
-- the objects contained in the dms_sample account.
-- It is recommended that you change the password
-- after creating the account.
---------------------------------------------------------
@user/create_dms_user.sql
@user/dms_user_privileges_onprem.sql

--------------------------------------------------------
--
-- If you want the dms_user to use the Schema Conversion 
-- Tool (SCT) you will need to give them the following privileges
--
--------------------------------------------------------
@user/dms_user_sct_privileges.sql



--------------------------------------------------------
--
-- !!! log in as the user DMS_SAMPLE
--
---------------------------------------------------------
-- run the following scripts:
alter session set current_schema = dms_sample;
@schema/load_base_data.sql
@schema/install_dms_sample_data.sql


-- stop spooling
spool off