Database Schema creation ORA:02421

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.

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?

Quote:

---

Originally Posted by 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.

---

Login as user supplier_track and then try.

HTH