Re: Please help ---- Oracle free spaces

Someone wrote:

> Thanks for your reply. I did this is becoz I need to know how much space i
> need to allocate for the db after the deletion.
> I already deleted some of the data from the tables, then export, then
> import again to check on the reduced size of the db, but still getting the
> same result.
> What should i do now? Please help!!!!
>

Unfortunately that makes no sense to me at all. You still have not told me WHAT about the DB you want to size - is it really the tables, or is it the datafiles (disk space) for the tablespaces? (What are you trying to allocate after deletion? Disk, disk file, something else?)

If you want to empty out the tables and make the space IN THE TABLESPACE available for other uses, then you probably want the TRUNCATE command, not the DELETE command. However, I suggest you read about the truncate comand before using it - there are some implications that might affect you.

If you want to recover disk space, then you really need to spend some time in the concepts manual to understand the internals of tablespaces. Once allocated, it is difficult to reduce the size fr the data files in the tablespace. Not impossible, just difficult.

You are getting the same size because Oracle does not give back what it has received. Tables hold a high water mark and appear to stay at their maximum size. Disk files generally stay at their maximum size. This is NORMAL for Oracle operation.

However, UNTIL YOU TELL US THE ORACLE VERSION and operating system, please don't expect any further ideas or help. That information IS important! Received on Thu Oct 21 2004 - 23:35:58 CDT