| schema [message #90585] |
Tue, 27 April 2004 04:13  |
Raj
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  |
Michael RIngbo
Messages: 18
Registered: April 2004
|
Junior Member |
|
|
Hi,
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
