Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Data File Size
"Howard Carr" <hcarr_at_cb.kruger.com> wrote in message
news:%EOg7.25444$Nc3.2640738_at_news20.bellglobal.com...
> I have a new database created on a new Oracle installation (8i on Win2000)
> on 8GB hard drives. The database has several tables which have only just
> started to be used.
> The biggest table has 15,550 rows at an @ row size of 60.
> The problem is that the data file is showing 5.5GB, and can't create any
> more extents because the disk is full.
> What has caused the database to reflect this much storage requirement?
> How do I fix the problem?
> I estimate that I have no more than 10MB of info in all the tables.
>
> Thanks for your help.
Can you extract the DDL for the table(s) in question and post it? There may be a problem with pctfree/pctused, but it's unlikely that it would cause this much wasted space on a table that's "just started to be used". Received on Wed Aug 22 2001 - 09:00:28 CDT