Hi friends, I have a question that I really need to solve. Please help me, any answer that can explain me what is happening will be very appreciated.

Recently I performed an import operation that succesfully created all the tables and rows of the schema Y. The information was imported using the option compress=n. At the moment I don't know if this is relevant to the problem, but I think is a good idea tell you what I have done. After that, the users have been using the database without any problems (using DML sentences), but in this moment I'm receiving an error from one application that is trying to insert some rows. The error is:

UNABLE TO EXTENT TABLE Y.X BY 5 IN TABLESPACE Z;

I think the problem is the segment of the table cannot extent anymore.

So I get these information from Oracle:

1) BLOCK SIZE:

show parameters db_block_size;

NAME TYPE VALUE
------------------------------------ ------- -----------
db_block_size integer 4096


2) STORAGE OF TABLE:

select * from dba_tables where table_name='X'

OWNER: Y
TABLE_NAME: X
TABLESPACE_NAME: Z
CLUSTER_NAME:
IOT_NAME:
PCT_FREE: 10
PCT_USED:
INI_TRANS: 1
MAX_TRANS: 255
INITIAL_EXTENT: 20480
NEXT_EXTENT:
MIN_EXTENTS: 1
MAX_EXTENTS: 2147483645
PCT_INCREASE:
FREELISTS:
FREELIST_GROUPS:
LOG: YES
B: N
NUM_ROWS:
BLOCKS:
EMPTY_BLOCKS:
AVG_SPACE:
CHAIN_CNT:
AVG_ROW_LEN:
AVG_SPACE_FREELIST_BLOCKS:
NUM_FREELIST_BLOCKS:
DEGREE: 1
INSTANCES: 1
CACHE: N
TABLE_LO: ENABLED
SAMPLE_SIZE:
LAST_ANA:
PAR: NO
IOT_TYPE:
...

2) SEGMENTS OF THE TABLE:

SELECT *
FROM DBA_SEGMENTS
WHERE segment_name = 'X' and OWNER='Y'

OWNER: Y
SEGMENT_NAME: X
PARTITION_NAME:
SEGMENT_TYPE: TABLE
TABLESPACE_NAME: Z
HEADER_FILE:12
HEADER_BLOCK:24819
BYTES:65536
BLOCKS:16
EXTENTS:1
INITIAL_EXTENT:20480
NEXT_EXTENT:
MIN_EXTENTS:1
MAX_EXTENTS: 2147483645
PCT_INCREASE:
FREELISTS:
FREELIST_GROUPS:
RELATIVE_FNO: 12
BUFFER_: DEFAULT

3) FREE SPACE IN THE TABLESPACE:

select max(bytes)/1048576 from dba_free_space
where tablespace_name = 'Z';

MAX(BYTES)/1048576
------------------
68,25


4) TABLESPACE INFORMATION :

select TABLESPACE_NAME,MAX_EXTENTS
from dba_tablespaces where tablespace_name='Z';

TABLESPACE_NAME: Z
BLOCK_SIZE: 4096
INITIAL_EXTENT: 65536
NEXT_EXTENT:
MIN_EXTENTS: 1
MAX_EXTENTS: 2147483645
PCT_INCREASE:
MIN_EXTLEN: 65536
STATUS: ONLINE
CONTENTS: PERMANENT
LOGGING: LOGGING
FOR: NO
EXTENT_MAN: LOCAL
ALLOCATIO: SYSTEM
PLU: NO
SEGMEN: AUTO


5)DATAFILES OF THE TABLESPACE:

FILE_NAME: C:\ORACLE\Z.ORA
FILE_ID: 12
TABLESPACE_NAME:Z
BYTES: 314572800
BLOCKS: 76800
STATUS: AVAILABLE
RELATIVE_FNO: 12
AUT: NO
MAXBYTES: 0
MAXBLOCKS: 0
INCREMENT_BY: 0
USER_BYTES: 314507264
USER_BLOCKS: 76784

As you can see the NEXT_EXTENT parameter of the table's storage is not present. In DBA-STUDIO the value showed is 0.
(I don't know the reason). But when I try to change this value to 10Mb (a multiple of the block_size) I get the error ORA-25150, telling me that the extent parameter value that I'm trying to use is not permitted. Also I have increased succesfully the size of the tablespace's datafile in 100 Mb. But I have the same bad results trying to modify the NEXT_EXTENT value...

I have concluded that:

* i) I don't know why the table cannot extent in the tablespace (ORA-01653 ).
* ii) I don't know why I cannot change the NEXT_EXTENT parameter of the table's storage in 10 Mb (ORA-25150).
* iii ) I don't know if I solve the point "ii)" will help me to solve the point "i)".

Thanks a lot for all your ansers

Regards