joehuang
asked on
How to create "Schema" in Oracle 9iR2 win2k edition ?
Oracle 9iR2 win2k Edition installed, I created user and tablespace thru sqlplus. I seen the user, tablespace and datafile in GUI on Oracle Enterprise Manager Console, but do not see Schema, Please advisr how to create the schema from the sqlplus and how to create the schema from GUI of OEM console.
thanks,
thanks,
A schema is basically a user that owns objects. If you grant the appropriate system permissions, and then create objects (i.e. tables, indexes, synonyms, etc) owned by the user, you will now have a schema, and OEM will display it as such in the GUI.
CREATE USER schemaname IDENTIFIED BY password DEFAULT TABLESPACE yourtablespacename TEMPORARY TABLESPACE yourtemptablespace;
GRANT CONNECT TO schemaname;
GRANT PUBLIC TO schemaname;
GRANT CREATE PROCEDURE TO schemaname;
ALTER USER schemaname QUOTA UNLIMITED ON yourtablespacename;
GRANT CONNECT TO schemaname;
GRANT PUBLIC TO schemaname;
GRANT CREATE PROCEDURE TO schemaname;
ALTER USER schemaname QUOTA UNLIMITED ON yourtablespacename;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.