A SERVICE OF

logo

Appendix C 515
ITO Tables and Tablespaces in the Database
ITO Tables and Tablespace
ITO Tables and Tablespace
An Oracle database uses tablespaces to manage the available disk space.
You can assign datafiles of a fixed size to tablespaces. The size of the
various datafiles assigned to a tablespace determines the size of the
tablespace.
To increase the size of a tablespace, you must add a datafile of a
particular size to the tablespace. You can do this interactively using the
Oracle tool, Server Manager, or using the sql command: alter
tablespace add datafile. Table C-1 on page 516 shows the default
tablespace design and the assigned database tables.
For more information about improving the performance of your database
see the online documentation in:
/opt/OV/ReleaseNotes/opc_db.tuning