Home » RDBMS Server » Server Administration » How to reclaim the space from a 25 GB table
How to reclaim the space from a 25 GB table [message #60685] |
Wed, 25 February 2004 15:49  |
kumarpk1008
Messages: 1 Registered: February 2004
|
Junior Member |
|
|
Hello everyone,
We are running Oracle 9.2 on AIX and I have the strange situation.
I have a table which normally will have only 3-4GB worth of data and due to problem this table has grown to a size of 25GB. We have managed to find the culprit program and removed the actual data from the table. But our issue is the 20GB space is locked to that table and we want to reclaim the space and make it available for the tablespace so that the other growing tables can make use of it.
I can hear you saying "Why can't you reorg the table or export table, recreate the objects and import the table back"
We can do but the problem is getting downtime on this system. With Oracle 9>, is there any new feature or facility which help us to do the same in somewhat easier way, without downttime ?? Some way of resetting the highwater mark??
Any clues, ideas, suggestions. Any help will be greatly appreciated.
Thanks and Regards� Kumar
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Apr 17 01:44:40 CDT 2025
|