My Oracle Support Banner

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 to [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:

Error starting at line 21 in command:
create user webcenter identified by webcenter default tablespace  temporary tablespace
Error at Command Line:21 Column:76
Error report:
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
Error report:
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
           system privileges.
           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
Error report:
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.