Background documentationVolume Locate this document in the navigation structure

 

The database system permanently stores the data and log entries of a database in volumes.

Volumes: Types

Type

Main Content

Data Volume

Data

Database Catalog

Undo Log Entries

Log Volume

Redo Log Entries

Volumes: Properties

Property

Description

Size

Minimum size: 1000 pages or 8000 KB

Device/File

Device/path and file name

Type

Type of physical memory

  • FILE (F)

    A volume can be a part of a physical hard disk, a complete physical hard disk, or a storage system consisting of several storage units.

    Can be used on all operating systems

  • LINK (L)

    Can only be used on Unix and Linux

  • RAW (R)

    Raw device

    Can only be used on Unix and Linux

Data Volume: Example

Property

Sample Data

Name

DATA0002

Size

256 MB

Device/File

C:\Documents and Settings\All Users\Application Data\sdb\data\demodb\data\DISKD0002

Type

FILE

Log Volume: Example

Property

Sample Data

Name

LOG002

Size

50 MB

Device/File

C:\Documents and Settings\All Users\Application Data\sdb\data\demodb\log\DISKL0002

Type

FILE

More Information