79877

Naming Schema Objects

Every object in the database belongs to one schema and has a unique name within that schema. Multiple database objects can share the same name, if they are in different schemas. You can use the schema name to unambiguously refer to objects. For example. hr. employees rcfers to the tablc namcd employees in the hr schema. (The

employees table is owned by hr.) The terms database object and schema object

are used

interchangeably.

When you create a database object, you must ensure that you create it in the intended schema. One method is to log in to the database as the user who owns the schema and then create the object. Generally, you place all the objects that belong to a single application in the same schema.

Notę: There is no rclationship bctween a tablespace and a schema.

Objects in the same schema can use storage in different tablcspaccs. and a tablespace can contain data from different schcmas.

About Schema Object Management Privileges 8-2 Oracle Database 2 Day DBA

A schema object name must abide by certain rulcs. In addition to bcing unique within a schema, a schema object name cannot be longcr than 30 bytes and must begin with a letter. If you attempt to create an object with a name that violatcs any of thcsc rules, then the database raises an error.