Create schema command error
500237Dec 5 2007 — edited Dec 5 2007Hi,
I tried to execute the following statement but was given the error.
1 CREATE SCHEMA AUTHORIZATION ashish
2 CREATE TABLE paint
3 (paint_id NUMBER PRIMARY KEY,
4 paint_size NUMBER,
5 colour VARCHAR2(10) )
6* GRANT select ON paint TO ashish
SQL> /
CREATE SCHEMA AUTHORIZATION painter
*
ERROR at line 1:
ORA-02421: missing or invalid schema authorization identifier
What is the error in this statement for not alllowing me to crate the schema?
This is 11g database.
Thanks,
Aashish