Sathish David Kumar N
asked on
create Database schema in oracle 10g
Hi ,
How to create Database schema in oracle 10g.
Thanks,
Sathish
How to create Database schema in oracle 10g.
Thanks,
Sathish
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
new schemas are created in a database...
so, schema and database are different.
all schemas have their own objects. vs...
to create a new schema,
CREATE USER <your_schema_name> IDENTIFIED BY "<your_password>"
DEFAULT TABLESPACE "<your_tablespace>"
TEMPORARY TABLESPACE "<your_temp_tablespace>";
after creating a schema,
you should grant your schema to create a session, to create an objects, vs...
so, schema and database are different.
all schemas have their own objects. vs...
to create a new schema,
CREATE USER <your_schema_name> IDENTIFIED BY "<your_password>"
DEFAULT TABLESPACE "<your_tablespace>"
TEMPORARY TABLESPACE "<your_temp_tablespace>";
after creating a schema,
you should grant your schema to create a session, to create an objects, vs...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER