SYS_MEDIA_DESCRIPTIONS

Information on file attributes and media types for database-specific files.

Column name

Data type

Contents

FILE_TYPE

CHAR (6)

File type:
DALOG
CATLOG
PBI
CATREC
DDLTA

DEVICE_DESCRIPTOR

CHAR (18)

Device type or name of the storage group
for the file

MEDIUM

CHAR (4)

DISC

ORDINAL_POSITION

SMALLINT

Sequence number of the entry in the
media table

REQUESTS

VARCHAR (3)

YES	Volume can be requested at console
NO	Volume cannot be requested at console

PRIMARY_ALLOC

INTEGER

Primary allocation

SECONDARY_ALLOC

INTEGER

Secondary allocation

SHARABLE

VARCHAR (3)

File sharable:
YES
NO

Table 118: SYS_MEDIA_DESCRIPTIONS view of the SYS_INFO_SCHEMA