Re: Tables Quota Usage - How?

Hi Emil,

By recreating the objects. There's no "squish" or "defragment" or "reset HWM" command. Yet, although there might be soon ...

To recreate the table, you have your choice of ALTER TABLE MOVE, CTAS, Export/Import, DBMS_REDEFINITION, etc.

To recreate the index, you can ALTER INDEX... REBUILD

However, note if you're planning to reinsert new data, then Oracle will effectively reuse this space (all things being equal) making these operations redundant. Perhaps ?

Cheers

Richard

"Emil Nikolov" <emil_nikolov_at_hotmail.com> wrote in message news:461451f7.0209160936.339ab256_at_posting.google.com...
> I found the source of the irrelevant data and deleted the rows I don't
> need.
>
> How can I force the tables and the corresponding indexes that I
> cleaned, to shrink/compress that unused space?
>
> Thanks again.
>
> Emil Nikolov
>
> emil_nikolov_at_hotmail.com (Emil Nikolov) wrote in message
news:<461451f7.0209050818.42237d4d_at_posting.google.com>...
> > Is there a way to find out what table is using what amount of space?
> > I know how to get the total user quota usage, but if I can get it to a
> > table level it would be much more helpful.
> >
> > Thanx.
> >
> > Emil Nikolov
Received on Tue Sep 17 2002 - 07:11:04 CDT