This content has been marked as final. Show 11 replies
Releasing space from where?
Many unix systems will hold the space until the DB is restarted. You did not mention your OS so that is strictly a guess.
My suggestion is
- you stop using IM-speak, and write 'Please' instead of 'pls', as that is considered rude
- You always ask clear questions (you didn't even specify the command you used)
- You always specify your platform
- You always consult documentation prior to asking any question
This is not a chat room!!!
Senior Oracle DBA
OS VERSION IS : HP-UX
Mention the clause *'including contents and datafiles'* in your drop tablespace command.1 person found this helpful
Otherwise the datafiles continue to exist physically.
Now you have to remove those datafiles physically using 'rm' command. Do it carefully
Edited by: krramnik on May 5, 2012 12:02 AM
Can you paste the lines from alert log for the drop tablespace command till it shows completed? Are the datafiles removed from OS level?
You could check if the datafiles from tablespace you dropped still exists:
select file_name, bytes/1024/1024 from dba_data_files where tablespace_name='&nametablespace';
Just to remember: oracle is case sensitive.
Hope that helps.
Thanks to all....
You might also check out the fuser command to see if Oracle has the file open, and consider getting the lsof package for future issues.
Thanks for the useful tip
Thanks to all....
Post your solution. People spent time trying to help you and all you can say is 'Got it'?
The forum is here to help people. That means everyone.
If you want help then you have a responsibility to provide help too by sharing what the solution was.
The solution is,
Physically the file is existed in the OS level still....
That is the reason the space is not releasing.....
So we decide it to remove manually...