Reference Manual: Commands

Examples

Example 1

Adds 1MB to the with a 2K page size database mydb on a default database device:

alter database mydb

Example 2

Adds 3MB to the space allocated for the pubs2 database on the database device named newdata:

alter database pubs2 on newdata = 3

If you do not provide a unit specifier for size, the value provided for newdata is presumed to be in megabytes.

Example 3

Adds 10MB of space for data on userdata1 and 2MB for the log on logdev:

alter database production 
on userdata1 = "10M"
log on logdev = '2.5m'

You can use both single and double quotes, and both "m" and "M" as size specifiers.


	Expand Search