5
Database Administration
Increasing Database Storage Size
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 219
8
Enter connect internal
9
Enter alter tablespace system
10
Enter add datafile ‘/oracle/dbs/dbsA2.dbf’
Note:
The file name
dbsA2.dbf
is a recommended name. If this file
already exists in this directory, use
dbsA3.dbf
11
Enter size number
where number
is the number of bytes calculated in
step 6
that you want to
add to the database.
12
Enter exit
Note:
We recommend that you use the above commands as written.
However, if you are concerned about the /oracle file system size,
substitute the add datafile ‘/home2/dbsA2.dbf’ command for
add datafile ‘/oracle/dbs/dbsA2.dbf’ above.
13
Enter /vs/bin/util/dbfrag
The system displays the number of free database blocks.
14
Check that the database size has been increased as desired.
15
Enter exit
The system exits the system manager mode.
16
Enter exit
