Good morning dear Guru's!
Now I've dropped TEMP tbs.
My steps:
1. Turn db to restricted session.
2. Create TEMP2 tbs and set it as Default temporary tbs (bcs oracle didn't
allow me first drop prev.TEMP tbs)
This tbs was created with 3 datafiles each 1Gb, locally managed and uniform
allocation. I couldn't change this params.
3.Then only dropped old TEMP tbs, then deleted OS files.
4. Turn db back to normal mode. (First forgot it, then only after first ungry
user's call did this.)
So everything was successfull only with your great help!!!
Thank you very much everybody for your great advices and help!!!
God bless you all!
Regards
--
Confusius
Senior Software Engineer
IT Dept.
International KZ-TR University, KZ

Oracle LazyDBA home page