Naming Schema Objects - wykład

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 refers to the table named 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.
Note: There is no relationship between a tablespace and a schema.
Objects in the same schema can use storage in different tablespaces,
and a tablespace can contain data from different schemas.
About Schema Object Management Privileges
8-2 Oracle Database 2 Day DBA
A schema object name must abide by certain rules. In addition to being unique within
a schema, a schema object name cannot be longer than 30 bytes and must begin with a
letter. If you attempt to create an object with a name that violates any of these rules,
then the database raises an error.
... zobacz całą notatkę