Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Freeing up system table space
Hello to all ,
When droping a user (cascade) that owns a lot of stored procedures, I noticed that Oracle does not free up space in the system table space. I assume that the reason is that extents are not freed up when droping rows from the system tables. Is there any way to free this space other than doing a complete export/import of the DB ?
Thanx in advance ,
Alon Received on Tue Oct 20 1998 - 11:36:13 CDT