Home » RDBMS Server » Backup & Recovery » Recover back space from datafiles
Recover back space from datafiles [message #42548] Wed, 09 April 2003 04:18 Go to next message
Messages: 20
Registered: October 2002
Junior Member

can someone show me the command to recover back the allocated space given to a datafiles.

fyi, I've created a datafile with sum of space in a tablespace. now i want to drop the tablespace. after dropping the tablespace i can see that the used space does not reduce? why?
Re: Recover back space from datafiles [message #42554 is a reply to message #42548] Wed, 09 April 2003 10:02 Go to previous message
Messages: 161
Registered: August 1999
Senior Member
Until Oracle 8i, if you drop a particular tablespace, the underlying datafiles do not get dropped automatically. The user have to "cd" to that directory and physically remove the datafile using an OS command ( 'rm' in Unix ). Until then, used space will not change.

In Oracle 9i this problem has been taken care of. If a tablespace is dropped, all the underlying tablespaces are also dropped automatically.

Have fun.
Previous Topic: Hot Backup Urgent help please
Next Topic: About Incremental Backup/Restore
Goto Forum:

Current Time: Fri Jun 02 06:11:28 CDT 2023