Very Computer

1. Tablespace problem

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).

I would appreciate any comments or suggestions that anyone might have
regarding this problem.

Thank you,

Shari Bishop
Database Analyst

2. problem with internet connection in 2000

3. temporary tablespace problem

4. Anyone had an HP inkjet print way too dark?

5. Alter tablespace problems

6. ID font please

7. Oracle 9i XMLType temp tablespace problem

8. How do I *disable* motherboard SCSI on A3000?

9. moving from tablespace a to tablespace b

10. New tablespace, new user with full access to tablespace?

11. Moving a table from one tablespace to another tablespace

12. 8i Tablespace removal if someone has deleted the .dbf instead of dropping the tablespace

13. Problem on dropping a tablespace (HELP !)