Reclaiming disk space from tablespaces
From: Madhu Bandireddi <bandired_at_myhost.subdomain.domain>
Date: 17 Aug 1994 21:53:31 GMT
Message-ID: <32u0sr$kmo_at_server.st.usm.edu>
Thanks
Madhu
Date: 17 Aug 1994 21:53:31 GMT
Message-ID: <32u0sr$kmo_at_server.st.usm.edu>
Hi!
We have Oracle 6.0 running on a TI SVR4 platform. We had to add tablespace of about 20 Meg temporarily to one of our tablespaces for a research project. Accidentally we ended up adding up about the same amount of space to our System tablespace too. Now that we are running low on disk space on our machine we want to reclaim the disk space from these tablespaces without losing any data or corrupting the database. Would someone please help me on this task?
Thanks
Madhu
-- ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Madhu Bandireddi Email: bandired_at_whale.st.usm.edu bandired_at_eagle.st.usm.edu Phone: (601) 266-5824 (601) 261-5678 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Smoking is one of the leading causes of statistics. -- Fletcher KnebelReceived on Wed Aug 17 1994 - 23:53:31 CEST