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.
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.
Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
Politically sensitive content
Content concerning pornography, gambling, and drug abuse
Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."