About create schema [message #370548] |
Fri, 17 December 1999 14:53 |
Kavitha
Messages: 40 Registered: December 1999
|
Member |
|
|
Hi,
Does this CREATE SCHEMA command creates a schema?Do we need to create a schema before creating any tables or when we create a user the schema will be created.If we create a user and that user creates some tables then thos tables belong to his schema or he has to create a schema and create tables?If one does not create schema before creating objects what happens?
|
|
|
Re: About create schema [message #370549 is a reply to message #370548] |
Fri, 17 December 1999 15:37 |
Sree Palavali
Messages: 4 Registered: December 1999
|
Junior Member |
|
|
Each Oracle database user can have one and only one schema and the schema will have the same name as the user. When you create a user and create objects as that user, the objects will be automatically a part of the schema and will be owned by that user.
'create schema' is just a command to issue multiple DDL statements in one transaction. You don't have to use create schema command. You can just log on as the user and start creating objects.
Good luck
Sree
|
|
|