Creato da pastuweb.com
Share My Page
My Social Accounts
Account FaceBook Account LinkedIn Account Twitter Account Google Plus Account Git Hub

if you have an error like this:

ORA-01688: unable to extend table ORA-01688: unable to extend table AUDSYS.CLI_SWP$2c9b4f87$1$1
partition HIGH_PART by 128 in tablespace SYSAUX . partition  by  in tablespace
))
        at com.liferay.counter.service.persistence.ConnectionHeartbeatJob.execute(ConnectionHeartbeatJob.java:55)
        at com.liferay.portal.job.JobWrapper.execute(JobWrapper.java:69)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
 
Open Toad or SQL Developer and exec this command:
SELECT * FROM DBA_DATA_FILES;
otuput:
2 D:\ORACLEXE\ORADATA\XE\SYSAUX.DBF   3       SYSAUX         450887680    55040   AVAILABLE
 
Then exec this command to resize datafile:
ALTER DATABASE DATAFILE 'D:\ORACLEXE\ORADATA\XE\SYSAUX.DBF' RESIZE 6000M;
 
or, you can add a new datafile to the tablespace:
ALTER TABLESPACE USERS ADD DATAFILE 'D:\ORACLEXE\ORADATA\XE\SYSAUX.DBF' SIZE 50M;
 
Finally, restart the Application Server that use that Oracle db.