Allocate More Space for a Database (37)

The size of a tablespace is the size of the datafiles that constitute the tablespace. The
size of a database is the collective size of the tablespaces that constitute the database.
You can enlarge a database in three ways:
1 Add a datafile to a tablespace
2 Add a new tablespace
3 Increase the size of a datafile
When you add another datafile to an existing tablespace, you increase the amount of
disk space allocated for the corresponding tablespace. Figure 3–2 illustrates this kind
of space increase.
The third option for enlarging a database is to change a datafile’s size or let datafiles in
existing tablespaces grow dynamically as more space is needed. You accomplish this
by altering existing files or by adding files with dynamic extension properties.

三种方法增大数据库的大小
1 新增数据文件
2 新增表空间
3 加大数据文件的大小 (autoextent on)

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-972486/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-972486/