Jeff,
There are three main reasons why a data file will not autoextend:
1) Maxbytes < bytes. If you use the OEM GUI do remember that it defaults to
KB. That dog has bitten me more than once.
2) The file system is >= 100% full. You can't autoextend nto something that
the OS won't give you.
3) The increment_by would cause the datafile to autoextend beyond maxbytes.
Pass the salve if you please!! I just got bit again.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
Sent: Monday, June 30, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
This morning I started getting "ORA-1654: unable to extend index
CIMXDBIN.CIMX_SESSION_STATE_PK by 128 in tablespace CAPP_IDX " in
my alert log (8.1.7 on Windows 2000). I checked my tablespace is has one
datafile with autoextend enabled.
FILE_NAME FILE_ID
TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO
AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
-------------------------------------------------- ----------
------------------------------ ---------- ---------- --------- ------------
--- ---------- ---------- ------------ ---------- -----------
E:\ORACLE\ORADATA\CIMX\CAPP_IDX.ORA 4 CAPP_IDX
314572800 38400 AVAILABLE 4 YES 1949696 238
3200 314564608 38399
To resolve the error I manually resized the datafile to 300M. Any ideas on
why the autoextend didn't work?
Thanks,
Jeff
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Eberhard, Jeff
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Goulet, Dick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
