Database Schema creation ORA:02421

[bayflash27]

Hi,

I logged in as SYS/SYSDBA and tried to create the following schema:

create schema authorization supplier_track;

I get error 02421, is the syntax wrong?

Thanks.

[davey23uk]

02421, 00000, "missing or invalid schema authorization identifier"
// *Cause: the schema name is missing or is incorrect in an authorization
// clause of a create schema statement.
// *Action: If the name is present, it must be the same as the current
// schema.


doesnt the error tell you wahat the problem is?

[adewri]

Hi,

I logged in as SYS/SYSDBA and tried to create the following schema:

create schema authorization supplier_track;

I get error 02421, is the syntax wrong?

Thanks.

Login as user supplier_track and then try.

HTH