Create Table Fails With ORA-1031 insufficient Privileges in 12.1

(Doc ID 2391282.1)

Last updated on MAY 01, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Create Table Fails with 'insufficient privileges' - 12.1

SQL> SET TERM ON;
SQL> WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
SQL> SET DEFINE OFF;
SQL> -- Table Details
SQL> --DROP TABLE T_INTERIM_FACT_CAT_HOLD;
SQL> CREATE TABLE "SURP01DBO"."T_INTERIM_FACT_CAT_HOLD"
 2   ( INTERIM_ID     NUMBER    GENERATED BY DEFAULT ON NULL AS IDENTITY ( START WITH 1 NOCACHE ) NOT NULL PRIMARY KEY
 3   , EXT_TABLE_SCHM_NM  VARCHAR2 (  30 ) NOT NULL
 4   , EXT_TABLE_NM   VARCHAR2 (  30 ) NOT NULL
 5   , EXT_TABLE_KEY   VARCHAR2 (  30 ) NOT NULL
 6   , EXT_TABLE_TYP   VARCHAR2 (  10 ) NOT NULL
 7   , EXT_TYP_NM   VARCHAR2 (  50 )
 8   , TARGET_COL_TXT   VARCHAR2 ( 255 ) NOT NULL
 9   , TARGET_COL_OPRT    VARCHAR2 (  15 ) NOT NULL
10   , TARGET_COL_VAL_1   VARCHAR2 ( 255 )
11   , TARGET_COL_VAL_2   VARCHAR2 ( 255 )
12   , TARGET_COL_VAL_3   VARCHAR2 ( 255 )
13   , CRE_D       DATE    NOT NULL
14   , CRE_USR_C   VARCHAR2 (  30 ) NOT NULL
15   , UPD_D       DATE    NOT NULL
16   , UPD_USR_C   VARCHAR2 (  30 ) NOT NULL
17   , COMMENTS   VARCHAR2 ( 500 )
18   , CONSTRAINT T_INTERIM_FACT_CAT_HLD_CONSTR UNIQUE ( EXT_TABLE_KEY )
19   );
CREATE TABLE "SURP01DBO"."T_INTERIM_FACT_CAT_HOLD"
*
ERROR at line 1:
ORA-01031: insufficient privileges

Changes

 No changes

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