beautypg.com

HP R4.2 User Manual

Page 258

background image

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