Menu
Calling all Oracle Gurus!
I am in the process of clustering a well tested application on WebSphere. The application in question made it about half way through processing 1k of JMS messages from a queue before this happened.
---- Begin backtrace for Nested Throwables java.sql.SQLException: ORA-01654: unable to extend index DABUAT.INDEX1 by 128 in tablespace DABUAT_TBLSP at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) I have had a quick look online and found a few possible suggestions as to why this could have happend, if anyone could give a clear explanation as to why this may have occurred now my application has been clusterd I would be most grateful.
Regards Karl
535
Increase the size of the tablespace If you haven't turned on the autoextend feature and want to resize the tablespace, then do the following: For bigfile tablespaces: Resize the tablespace using the ALTER TABLESPACE command. You can specify the size in kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T).
The following example enables automatic extension for a datafile added to the users tablespace: ALTER TABLESPACE users ADD DATAFILE '/u02/oracle/rbdb1/users03. dbf' SIZE 10M AUTOEXTEND ON NEXT 512K MAXSIZE 250M; The value of NEXT is the minimum size of the increments added to the file when it extends.
SELECT dfq. tablespace_name AS "Tablespace Name", dfq. totalspace AS "Total Size MB", (dfq.
You are out of disk space.
Increase your TABLESPACE:
ALTER TABLESPACE DABUAT_TBLSP ADD DATAFILE 'C:\FolderWithPlentyOfSpace\DABUAT_TBLSP001.DBF' SIZE 4M AUTOEXTEND ON NEXT 4M MAXSIZE 64G; -- Put your own size parameters here If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
