Home » Developer & Programmer » Designer » schema
schema [message #90585] Tue, 27 April 2004 04:13 Go to next message
Messages: 411
Registered: November 1998
Senior Member
what is schema. plz describe it.
how does it relates to user.
is user or schema is one thing;

plz reply.
Re: schema [message #90587 is a reply to message #90585] Tue, 27 April 2004 23:03 Go to previous message
Michael RIngbo
Messages: 18
Registered: April 2004
Junior Member

Qouting Oracle Concepts manual:
"A schema is a collection of database objects that are available to a user. Schema objects are the logical structures that directly refer to the database's data. Schema objects include such structures as tables, views, sequences, stored procedures, synonyms, indexes, clusters, and database links. (There is no relationship between a tablespace and a schema; objects in the same schema can be in different tablespaces, and a tablespace can hold objects from different schemas.)"

Regards, Michael
Previous Topic: Migration from oracle 8.0.6 to oracle 9i
Next Topic: relation
Goto Forum:

Current Time: Wed Mar 22 00:17:21 CDT 2023