Previous Topic: Physical Database DescriptionNext Topic: Areas and Pages


Segments

A segment represents a physical instance of all or a portion of a database whose logical contents are described by a schema. A segment defines the areas and files that contain the data for one database instance.

At Commonweather, for example, two database instances exist: one for testing and one for production. A single schema describes the logical contents of both databases, but two segments are defined to hold the data: the TESTHR segment identifies the physical characteristics of the test database and the PRODHR segment identifies the physical characteristics of the production database.