Database Administration (MOSC)

MOSC Banner

ORA-01654

edited Mar 22, 2010 11:28PM in Database Administration (MOSC) 14 commentsAnswered
 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
------------------------------ --- ------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center