Error: "ORA-00922: missing or invalid option" Running STARETL During Execution Of The Script To Create The Data Warehouse Schema User (Doc ID 2059742.1)

Last updated on DECEMBER 08, 2016

Applies to:

Primavera Data Warehouse - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

The STARETL fails with the following error.

TIMESTAMP staretl [ERROR] (Message) - [TIMESTAMP] ORA-00922: missing or invalid option ORA-06512: at line 15
TIMESTAMP staretl [ERROR] (Message) - [TIMESTAMP] Database Error: error number=922
TIMESTAMP staretl [ERROR] (Message) - [TIMESTAMP] Error Message: ORA-00922: missing or invalid option ORA-06512: at line 15
TIMESTAMP staretl [ERROR] (Message) - [TIMESTAMP] DECLARE user_created_already EXCEPTION;
PRAGMA EXCEPTION_INIT(user_created_already, -1920);
BEGIN
EXECUTE IMMEDIATE 'create user STARUSER
identified by !!@!!2222!!@@!!      
temporary tablespace TEMP
default tablespace STAR_DAT1
quota unlimited on STAR_DAT1
quota unlimited on STAR_HST1';
EXCEPTION
WHEN user_created_already THEN
dbms_output.put_line('user already created, skipping creation of STARUSER');
WHEN OTHERS THEN
RAISE;
END;
<TIMESTAMP> staretl [ERROR] (Message) - [TIMESTAMP] Script Failed

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms