Execute a script similar to the following as the system DBA.
-- Create tablespace and a user for warehouse CREATE TABLESPACE idm_warehouse_ts DATAFILE ’D:/Oracle/warehouse/idm_warehouse.dbf’ SIZE 10M AUTOEXTEND ON NEXT 10M DEFAULT STORAGE (INITIAL 10M NEXT 10M); CREATE USER idm_warehouse IDENTIFIED BY idm_warehouse DEFAULT TABLESPACE idm_warehouse_ts QUOTA UNLIMITED ON idm_warehouse_ts; GRANT CREATE SESSION to idm_warehouse;
To load the DDL, execute the following command
sqlplus idm_warehouse/idm_warehouse@idm_warehouse < create_warehouse.oracle