![]() ![]() This chapter describes tables, views, materialized views, sequences, synonyms, indexes, and clusters. Figure 10-1 illustrates the relationship among objects, tablespaces, and 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. 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. The data of each object is physically contained in one or more of the tablespace's datafiles. However, Oracle stores a schema object logically within a tablespace of the database. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. Schema objects are logical data storage structures. Examples of schema objects include tables, views, sequences, synonyms, indexes, clusters, database links, snapshots, procedures, functions, and packages. A schema is a collection of schema objects. It includes:įor information about additional schema objects, see "Database Links", "Stored Procedures and Functions", "Packages", and Chapter 20, "Triggers".Īssociated with each database user is a schema. This chapter discusses the different types of database objects contained in a user's schema. My object all sublime I shall achieve in time-To let the punishment fit the crime. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |