<<Previous Next>>
Oracle - What is a
schema? - Feb 07, 2010 at 14:20 PM by Shuchi
Gauri
What is a
schema?
A schema is a collection of database objects.
Schema objects are logical structures created by users to contain
data. Schema objects include structures like tables, views, and
indexes.
Oracle - What
is a schema? - April 10, 2009 at 11:00
AM
What is a schema?
Schema represents structure of the database.
Database has two main types of schemas partitioned.
Physical schema: Describes the database design at the physical
level. Logical Schema: Describes the database design at the
logical level.
Logical Schema is important from a programmer’s point of view
since it is used extensively during software development.
Oracle - What is a schema? - June 18, 2009 at
17:00 PM
The set of objects owned by user account is called the schema.
Also read
The list of all indexes in a schema can be obtained through the
USER_INDEXES view with a SELECT statement:...........
Schema objects are the logical database structure that represents
database's data. Schema objects include tables, views, sequences,
synonyms, indexes, clusters, database............
Archiving is the process of removing of old data and unused data
from the main databases. This process keeps databases smaller, more
manageable and thus acquires..............
|