Robert Geier wrote:No I am not killing the sessions... But i just checked using following query that some users are using the temp Tablespace at that time. But i did not kill any session.
If you kill the sessions using the tempfile, or restart the database you may be able to drop it. Or you could try to shrink the tempfile instead of drop.
Not sure why you are doing that though ? If the temp tablespace is full, check what is using the space, or add another tempfile to the tablespace.
Asit Kumar Mohanty wrote:Why ? Metalink account exists to solve problem like this
In This company they are not giving me metalink Id. Thats why i am facing lots of problem. But some where i check that The Argument: , [0x033134908], ,  is a bug in 9i and 10gR2, its right or wrong still i am confuse.... Plz give me some solution for this....
Asit Kumar Mohanty wrote:are you bragging or complaining?
Recently i joined this company. I asked my manager for metalink Id but he told me that the account is expired. we will arrange a new account soon. I am the only dba in this company.... so facing lot of problem.....