Data Storage

A DBA can determine which tables and indexes reside on a given dbspace, relocate objects to other dbspaces, and drop any dbspace after emptying it of data.

A DBA can also define the number of writes to each dbspace before the disk striping algorithm moves to the next stripe.

• Dbfile Attributes and Operations
  A dbfile has read-write or read-only status.
• Dbspace Attributes and Operations
  Dbspace statuses can be online, offline, or dynamically offline.
• Read-only and Read-write Dbspaces and Files
  A file is read-only when either the file status is read-only or the file status is read-write, but the owning dbspace status is read-only.