| Recover back space from datafiles [message #42548] |
Wed, 09 April 2003 04:18  |
noor
Messages: 20
Registered: October 2002
|
Junior Member |
|
|
hi,
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  |
Anand
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.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
