Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

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
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
                while MAXSIZE 64G stands for 64 Giga bytes, so always add less than your current free size, else it will give the same error.
– emarshah
                Jul 11, 2016 at 14:59
                Hi, I am getting following error for this. java.sql.SQLException: ORA-01654: unable to extend index ODM_DSI.EVENTSTORE_IDX2 by 1024 in tablespace USERS. will extending tablespace will again help here?
– Pranav Nath
                Jun 13, 2017 at 9:39
IF you are using ASM then you can add with below comment
you can run below command to get size of datafile 
SELECT
    file_name,
    bytes / 1024 / 1024 mb
    dba_data_files
WHERE
    tablespace_name = 'APP_DATA'
ORDER BY
    file_name;
FILE_NAME mb
------------------------------------------------------------ -------
+DATA/SID/datafile/app_data.dbf 20000
+DATA/SID/datafile/app_data.dbf 28100
Resizing and adding
+DATA/path/indx_operational_00.dbf
alter database datafile '+DATA/path/indx_operational_00.dbf' resize 3000m;
I found this question having same error migrating small subset of large database into test database in Docker.
In my case the problem was simply in using system tablespace for user tables, which was default setup in Oracle image. After creating custom tablespace using command
create tablespace mytablespace datafile '/u01/app/oracle/oradata/XE/mytablespace.dbf' size 500M autoextend on next 250M maxsize 10G;` 
(as well as creating all tables and indexes in that tablespace) the problem disappeared. No special fiddling with datafiles was necessary.
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.