"missing authorization clause" while creating schema
database, oracle, schema
Solution
`CREATE SCHEMA` is used to create a whole set of objects in a single statement. It does not create "schema" the way other DBMS (e.g. PostgreSQL) use that term.
From the manual:
Use the CREATE SCHEMA statement to create multiple tables and views and perform multiple grants in your own schema in a single transaction
And the big note at the very beginning:
This statement does not actually create a schema. Oracle Database automatically creates a schema when you create a user
(Emphasis mine)
A schema and a user are (more or less) the same thing in Oracle. So most probably you are actually looking for:
create user scm identified by scm;
Problem
I am trying to create a database schema in Oracle using Enterprise Manager Console as: ``` CREATE SCHEMA SCM AUTHORIZATION SCM ``` but it is giving error as: "missing AUTHORIZATION clause". Can you please help.