Support > Knowledge Base
Knowledge Base
Search the Knowledge Base: |
Search the Knowledge Base: |
Extending the tablespace on an Oracle database
Symptoms
-
The VMware VirtualCenter Server service may crash unexpectedly.
-
VirtualCenter vpxd.log may show an error similar to the following when connected to a Oracle database:
ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-01653: unable to extend table <table> by <size> in tablespace <tablespace> is returned when executing SQL statement <SQL Statement > . -
VirtualCenter vpxd.log may show an error similar to the following when connected to a Oracle database:
ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-02478: merge into base segment would overflow MAXEXTENTS limit .
Resolution
When utilizing an Oracle database the database administrator has to be aware of the amount of space assigned to each tablespace that is being utilized. In more recent versions of Oracle an administrator can set the database to automatically extend so that constant monitoring is not required.
To manually extend the tablespace of a database:
-
Log in to to the Oracle server with an administrative account.
-
Open a utility such as SQL Plus and log in to Oracle.
-
Run the following query:
ALTER DATABASE DATAFILE <filename> RESIZE <size>;
where, <filename> is the path to the datafile and <size> is the size is the size you want to extend the database to in MB, for example 100M.
To configure the tablespace of a database to automatically extend:
-
Log in to to the Oracle server with an administrative account.
-
Open a utility such as SQL Plus and login to Oracle.
-
Run the following query:
ALTER DATABASE DATAFILE <filename> AUTOEXTEND ON NEXT <size> MAXSIZE <maxsize>;
where, <filename> is the path to the datafile, <size> is the size is the increment size by which you want to extend the database every time it is extended for example 1024, and <maxsize> is the maximum you want the tablespace to extend to in MB, for example 100M.
Note: If you want the tablespace to grow as required until the disk space is filled, <maxsize> can be set to UNLIMITED .
Permalink to: Extending the tablespace on an Oracle database
Actions
- KB Article: 1003982
- Updated: Aug 14, 2009
- Products:
VMware VirtualCenter