Getting ORA-00922 when Trying to Create the WebCenter Schema
(Doc ID 819003.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle WebCenter Portal - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11g]
Information in this document applies to any platform.
During the preparation steps of the WebCenter Tutorial, the following error is returned when trying to execute the script wc_schema.sql from SQL Worksheet of JDeveloper:
create user webcenter identified by webcenter default tablespace temporary tablespace
Error at Command Line:21 Column:76
SQL Error: ORA-00922: missing or invalid option
00922. 00000 - "missing or invalid option"
Error starting at line 22 in command:
grant execute on dbms_lock to &&1
SQL Error: ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
*Action: Ask the database administrator to perform the operation or grant
the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label.
Error starting at line 23 in command:
grant resource to &&1
SQL Error: ORA-01917: user or role 'WEBCENTER' does not exist
01917. 00000 - "user or role '%s' does not exist"
*Cause: There is not a user or role by that name.
*Action: Re-specify the name.
See the Tutorial
Step 4: Install the WebCenter Schema
Oracle Fusion Middleware Tutorial for Oracle WebCenter Developers
11g Release 1 (11.1.1)
Part Number E10273-01
for more information about the context.
This problem occurs when you accept the default values for the tablespace names.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document