How to use manual steps to create data warehouse (Oracle)
3 answers
We are actually using 4.0.
So the 4.0.3 probably doesn't apply to us.
I did read over the first article without actually put it into run.
Which it came down to this script. Is this script sufficient enough to create the data warehouse?
We have all those RIDW, RIODS....etc created.
Script:
So the 4.0.3 probably doesn't apply to us.
I did read over the first article without actually put it into run.
Which it came down to this script. Is this script sufficient enough to create the data warehouse?
We have all those RIDW, RIODS....etc created.
Script:
CREATE USER <etl db user> PROFILE DEFAULT IDENTIFIED BY <password> DEFAULT TABLESPACE USERS ACCOUNT UNLOCK; ALTER USER <etl db user> TEMPORARY TABLESPACE RIS_TEMP; ALTER USER <etl db user> QUOTA UNLIMITED ON VNF_32K; ALTER USER <etl db user> QUOTA UNLIMITED ON VNF_IDX; ALTER USER <etl db user> QUOTA UNLIMITED ON USERS; ALTER USER <etl db user> QUOTA UNLIMITED ON VSTR_32K; ALTER USER <etl db user> QUOTA UNLIMITED ON VSTR_IDX; GRANT CREATE SESSION TO <etl db user>; GRANT CONNECT TO <etl db user>; GRANT ANALYZE ANY TO <etl db user>; BEGIN FOR TABNAME IN (SELECT OWNER,TABLE_NAME FROM ALL_TABLES WHERE OWNER IN ('RIODS','RIDW','CONFIG','RIASSET','RISCHK','RICALM')) LOOP EXECUTE IMMEDIATE 'GRANT SELECT,UPDATE,DELETE,INSERT ON ' || TABNAME.OWNER || '."' || TABNAME.TABLE_NAME || '" TO <etl db user>'; END LOOP; END; / BEGIN FOR VNAME IN (SELECT OWNER,VIEW_NAME FROM ALL_VIEWS WHERE OWNER IN ('RIDW','RICALM')) LOOP EXECUTE IMMEDIATE 'GRANT SELECT ON ' || VNAME.OWNER || '."' || VNAME.VIEW_NAME || '" TO <etl db user>'; END LOOP; END; /
Hello Daniel,
this article could be a good start:
More Control over the Oracle Data Warehouse Setup
In version 4.0.3 you can also generate the DW creation scripts that you can review:
Repository tools command to generate data warehouse creation scripts
Best Regards
Francesco
this article could be a good start:
More Control over the Oracle Data Warehouse Setup
In version 4.0.3 you can also generate the DW creation scripts that you can review:
Repository tools command to generate data warehouse creation scripts
Best Regards
Francesco