Tables, Indexes, views, synonyms, procedures, packages etc that exists in database is reffered as objects. These objects grouped together logically is called schema. This schema is owned by a user and the name of schema is same as user.
Hence schema is nothing but a logical structure created by database users, which is a collection of database objects.
Every object in a database belogns ton one schema and each object has a unique name within the schema. All objects that belongs to a single application is placed in same schema.
There are certain naming conventions that need to be followed while creating a new object
* Name of each object should be unique
* Name of object cannot be longer than 30 character
* Must begin with a letter.
Violating any of these rules results in Oracle error.
No comments:
Post a Comment