Tablespace problem
Date: 1996/07/18
Message-ID: <4sltl8$2d3i_at_lamar.ColoState.EDU>#1/1
We are experiencing problems with ORACLE version 6. The database is very fragmented and attempts to defragment, such as running 'GEN_CREATES' have not been successful. Could anyone please explain to me what ORACLE version 6 really does when trying to create a table. For example: A database that has 11,145 blocks of free space (not continuous), and a user tries to create a table of 6,000 blocks. ORACLE displays an error 'ORA-01547: FAILED TO ALLOCATE EXTENT OF SIZE 6,000 IN TABLESPACE 'tablespace_name''. According to the manuals, ORACLE will go out and get non-contiguous free space if one continuous free space is not available. That does not seem to be what is happening. We have exported, recreated the tables, and imported the data, but it does not decrease the fragmentation. It only eliminated the various extents. We tried to drop the tablespace but ran into other problems with that process, and therefore we were not able to drop it (ORACLE is checking into that problem).
(Direct replies to sbishop_at_tasc.usda.gov) Received on Thu Jul 18 1996 - 00:00:00 CEST