One of our user had the following error loading data in a table in his own schema.
ORA-01631: max # of extents nnn reached in table
We are running Oracle 184.108.40.206 on Windows advanced server with db_block_size of 8192.
According to the documentation the ideal solution is to Increase the maximum number of extents allowed for the table, i.e:
For a 8K block size an object could have no more than 505 extents
storage (maxextents 500);
When I query the database as follows
SELECT max_extents , tablespace_name
WHERE table_name = 'USERS' AND owner = 'ower_name';
Why I am getting 2147483645 for max_extents instead of 505 FOR 8K block size
Can some one explain that?