Insufficient Tablespace

Publication Date:  2015-06-30 Views:  331 Downloads:  0
Issue Description
This topic provides the method to use for troubleshooting when the tablespace is insufficient because the daily settlement data volume is large and the tablespace size is fixed. At present, only the solution for the Oracle database is available.
Handling Process
1. Log in to the Oracle server as the oracle user.
su –orcle
2. Log in to the Oracle database as the sys user.
sqlplus / as sysdba
3. Run the following command to increase the tablespace size:
alter tablespace ICD_SERVICE add datafile 'E:\oracle\oradata\wldb\rdata51' size 1000M;
− ICD_SERVICE needs to be changed based on the site scenarios.
− E:\oracle\oradata\wldb\rdata51 needs to be changed based on the site scenarios.
− 1000M needs to be changed based on the site scenarios.
Root Cause
A message indicating that the tablespace is insufficient is displayed in the database.

END