INSTALLATION DOCUMENTS BY RAVI

Sunday, July 30, 2017

ORA-01950 no privileges on tablespace issue while running OBIA rcu

Error:

 CREATE TABLE "DEV_BIACOMP"."C_RPD_MSGS" ("MSG_ID" VARCHAR2(250 CHAR) NOT NULL ENABLE, "SEEDED_FLAG" NUMBER(1,0), "MSG_TEXT_TYPE" VARCHAR2(50 CHAR), "CREATED_BY" VARCHAR2(64 BYTE), "CREATION_DATE" TIMESTAMP (6), "LAST_UPDATED_BY" VARCHAR2(64 BYTE), "LAST_UPDATE_DATE" TIMESTAMP (6), "LAST_UPDATE_LOGIN" VARCHAR2(32 BYTE)) SEGMENT CREATION IMMEDIATE PCTFREE 10
ORA-39083: Object type TABLE:"DEV_BIACOMP"."C_BIEE_CURR_CODE_LKP" failed to create with error:

ORA-01950: no privileges on tablespace 'DEV_BIACOMP'

Solution : From oracle support

On researching the knowledge base, Found one of our other customer also faced rcu failure while installing 11.1.1.9.1 on Oracle 12c (12.1.0.2.0) and following workaround resolved the issue.

********************************************************
Backup the following file:

<rcu_home>/rcu/integration/biapps/sql/biapps_create_user.sql

Open the script biapps_create_user.sql, modify the line
FROM:
CREATE USER &&1 identified by &&2 default tablespace &&3 temporary tablespace &&4;

TO:
CREATE USER &&1 identified by &&2 default tablespace &&3 temporary tablespace &&4 quota unlimited on &&3;

************************************************************

After the change, run rcu again.

No comments:

Post a Comment

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...