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