Database Software

The schema name must be an existing Oracle username.

yes...I have created the user ashish first,granted all the necessary priviledges to it and then executed this statement.

This is the error info from the documentation:

ORA-02421: 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.

looks like you need to be connected as the user ashish.....

I could have sworn that your SQL used "painter", not "ashish"! Have you edited it?

yes...I have connected as user ashish only...
Actually I just picked up this example from oracle documentation and tried to execute it in the same way as guided...
Dont have any ckue about correctness..

This was trial only and have picked an example from one I found out on net only.

It's:

create 'user', not 'schema'

Hi,

It must be the same as the current schema.

LEGATTI@ORACLE10> show user
USER is "LEGATTI"

LEGATTI@ORACLE10> create schema authorization legatti
  2  create table t1 (id number)
  3  create table t2 (id number)
  4  create table t3 (id number)
  5  ;

Schema created.

Cheers

Legatti

check out the example on this page:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/general001.htm#ADMIN11523

does this work?

I wonder whether you have to define the NUMBER field length as the page says: The CREATE SCHEMA statement does not support Oracle Database extensions to the ANSI CREATE TABLE and CREATE VIEW statements, including the STORAGE clause.

You need to:
create a user called ashish
login to SQL*Plus as ashish
Run the CREATE SCHEMA thing with ashish after "CREATE SCHEMA AUTHORIZATION"

Thanks Rattus,neil,Harry and Eduardo...
It worked fine with your help...

Rgds,
Aashish S.