Use the monitor_add utility to add a new datafile to the database. When you add another datafile to an existing tablespace, you increase the amount of disk space allocated for the corresponding tablespace. Before adding a new datafile, determine how much space is available on the disk.
 | Note: Do not make a datafile larger than 2 GB if only tape backup is used. |
To add a new datafile to the tablespace
Run the monitor_add utility by typing
monitor_add (Solaris) or bash monitor_add (Windows)
To specify that you want to add a datafile to the database, at the prompt , type C to continue.
At the prompt, type the tablespace name—possibly mvfindex.
Type the path name for the datafile:
/usr/mvf/data/dbase/data1 (Solaris)
E:\data\dbase\data1 (Windows)
For the size of the datafile in megabytes, type 2000.
The following message appears:
Please wait while file is being created (may take a minute) ..Database file mvf02.dbf has been added.Monitor statistics updated.