Home » RDBMS Server » Server Administration » About create schema
About create schema [message #370548] Fri, 17 December 1999 14:53 Go to next message
Messages: 40
Registered: December 1999
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 Go to previous message
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
Previous Topic: Urgent : ORA-01041: hostdef extension doesn't exist
Next Topic: How to get a table's fields and their types in PL/SQL?
Goto Forum:

Current Time: Fri Oct 23 15:58:22 CDT 2020