Getting ORA-00922 when Trying to Create the WebCenter Schema

(Doc ID 819003.1)

Last updated on DECEMBER 23, 2016

Applies to:

Oracle WebCenter - Version: to


During the preparation steps of the 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.


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