User Cannot Create Table On Its Own Schema, When the Table name is not Prefixed with Owner Name (Doc ID 2814798.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

User cannot create table on its own schema.

create user user1 identified by ****;
grant create session, create table, unlimited tablespace to user1;

sqlplus user1
create table t1(n1 number);

This create table command fails with ORA-1031 error.

But if the schema name is prefixed with object_name in the create table command, then it succeeds.

This below command works:

create table user1.t1(n1 number);

Cause

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