huge Oracle error, table space USERS full?

Question

oracle.jdbc.driver.LogicalConnection@67149d
java.sql.SQLException: ORA-01653: unable to extend table FORMSPIDER.T_BDF_WEBSESSIONLOG by 128 in tablespace USERS
ORA-06512: at "FORMSPIDER.BDF_WEBSESSIONLOG_API", line 22
ORA-06512: at "FORMSPIDER.BDF_ENGINE", line 2046
ORA-06512: at "FORMSPIDER.BDF_ENGINE", line 2242
ORA-01653: unable to extend table FORMSPIDER.T_BDF_WEBSESSIONLOG by 128 in table space USERS
ORA-06512: at "FORMSPIDER.BDF_ENGINE", line 2359
ORA-06512: at line 1

These are the errors that my tomcat command line states. I cannot use shutdown.bat, it won't work. I have to close it manually. Formspider IDE gives me a popup message that says "An error occurred. Please contact your system administrator." I can open the API doc just fine.
Could you please help me?

Answer 1

Hi Mazzel,

It seems like your USERS tablespace is full, you should resize its datafile or add a new datafile for this tablespace. You can find more details about how to do this in the following documentation:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles003.htm#ADMIN11423

The t_bdf_websessionlog is a table holding all requests made to Formspider for a limited time period specified in bdf_setup table, you can check this value using this following query:

select value_tx from bdf_setup where var_cd = 'WebSessionLogDuration'

Note that the returned value is day based. For instance, if this value is 1, Formspider clears all logs belonging to closed apps after 1 day of their creation. You can always disable this logging mechanism by setting 0 as the WebSessionLogDuration value in bdf_setup table.

Hope this helps,
Ibrahim

huge Oracle error, table space USERS full?

Follow this question

Related questions