Hello,
Currently in my oracle 11g database, there are two datafiles under the users tablespace. Today during one application installation, I ran into this error msg:
ORA-01654: unable to extend index BSANITY.SI_CUID_I7 by 8 in tablespace USERS
So i checked the tablespace status in SQL developer and saw that the USERS tablespace is at 99% used. Datafile #1 is full at max size 32G and #2 is full at max size 4G. So I decided to change dbf #2 maxsize to 32G, I used the following command:
alter database datafile '<file path here>' autoextend on maxsize 32000M;
I checked the dba_data_files view and verified the maxbytes change.
However, when I check the tablespace status in SQL developer, it is still showing USERS tablespace as 99% used. I'm wondering is there anything else I need to do after altering the datafile maxsize so that the change gets reflected in SQL developer?
Thank you in advance!
Edited by: 939040 on Jun 11, 2012 12:05 PM