SPOOL USER.LOG

rem Creates cs_olap user and eif file directory

CREATE TABLESPACE cs_olap NOLOGGING DATAFILE '&1/cs_olap_01.dbf' size 325M reuse AUTOEXTEND ON NEXT 1M maxsize 2048M segment space management auto autoallocate;
CREATE TEMPORARY TABLESPACE cs_olaptemp TEMPFILE '&1/cs_olaptemp_01.dbf' size 325M reuse EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

create user cs_olap identified by cs_olap default tablespace cs_olap temporary tablespace cs_olaptemp quota unlimited on cs_olap;
grant unlimited tablespace, olap_user, olap_dba, dba, create materialized view to cs_olap;

create directory eifdir as '&2';
grant write on directory eifdir to public;
grant read on directory eifdir to public;
commit;
SPOOL OFF
quit;
