ORA-01654
Hi,
why I am getting this error when my tablespace is autoextendible.
ORA-01654: unable to extend index MSDP_MGMT.X$DSR1$USAG$APUR by 1024 in tablespace MSDP
I have checked the following.
SQL> select FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE,sum(bytes)/(1024*1024*1024) from dba_data_files where TABLESPACE_NAME='MSDP'
2 GROUP BY FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE;
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME AUT SUM(BYTES)/(1024*1024*1024)
------------------------------ --- ---------------------------
+DATA/msdp/datafile/msdp.261.664984049
MSDP YES 31.9999847
SQL> select FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE,INCREMENT_BY from dba_data_files where TABLESPACE_NAME='MSDP';
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME AUT INCREMENT_BY
------------------------------ --- ------------
ORA-01654: unable to extend index MSDP_MGMT.X$DSR1$USAG$APUR by 1024 in tablespace MSDP
I have checked the following.
SQL> select FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE,sum(bytes)/(1024*1024*1024) from dba_data_files where TABLESPACE_NAME='MSDP'
2 GROUP BY FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE;
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME AUT SUM(BYTES)/(1024*1024*1024)
------------------------------ --- ---------------------------
+DATA/msdp/datafile/msdp.261.664984049
MSDP YES 31.9999847
SQL> select FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE,INCREMENT_BY from dba_data_files where TABLESPACE_NAME='MSDP';
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME AUT INCREMENT_BY
------------------------------ --- ------------
0