Introduction to Schema Objects (153)

tsinglee發表於2007-11-07

A schema is a collection of logical structures of data, or schema objects. A schema is
owned by a database user and has the same name as that user. Each user owns a single
schema.
Schema objects are logical data storage structures. Schema objects do not have a
one-to-one correspondence to physical files on disk that store their information.
However, Oracle stores a schema object logically within a tablespace of the database.
The data of each object is physically contained in one or more of the tablespace’s
datafiles. For some objects, such as tables, indexes, and clusters, you can specify how
much disk space Oracle allocates for the object within the tablespace’s datafiles.
There is no relationship between schemas and tablespaces: a tablespace can contain
objects from different schemas, and the objects for a schema can be contained in
different tablespaces.

方案物件
1. 方案是一個邏輯資料結構或稱為方案物件 , 每個方案都術語一個資料庫使用者並與之同名 ,
一個使用者擁有一個方案 .
2. 方案物件是一種邏輯資料儲存結構 .

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981068/,如需轉載,請註明出處,否則將追究法律責任。

相關文章