Add space to database

DBA's frequently need to add space to a database to cater for database growth. Space can be added to a tablespace by adding more datafiles or by resizing existing datafiles. Use one of the following commands to add space:

If your installation uses RAW Volumes, pre-allocate the volume or get your Operating System Support to create if for you. This is typically done using commands like: vxassist (Veritas) or lvcreate (HP-UX).

Unless you know exactly what you are doing, never try to resize files on RAW Volumes.

Note that Oracle is busy desupporting RAW volumes. RAW can still be used in Oracle 11gR2 (upgraded databases). However, one cannot create NEW databases on RAW anymore. RAW will be completely desupported in Oracle 12.