| Unable to drop temp tablespace [message #64447] |
Sun, 30 January 2005 23:48  |
Vivek Vijai
Messages: 67
Registered: April 2004
|
Member |
|
|
The Temporary table became 100 % so I planned to create a new temporary tablespace and drop the old one.
I did the same and made new tablespace as default and then gave the drop command (from sqlplus ) including contents and datafiles
But the command is still going on. In OEM I can see for the tablespaces that USED is 0 % but the tablespaces isn't dropped yet.
Please let me know what should I do.
I want to get some free space on my server. Should I cancel the DROP command (Kill session) then drop the file using OS command.
Please let me know
Thanks in advance
Vivek.
|
|
|
|
| Re: Unable to drop temp tablespace [message #64452 is a reply to message #64447] |
Mon, 31 January 2005 01:04  |
Sreedhar Reddy
Messages: 55
Registered: January 2002
|
Member |
|
|
I think no need to drop the temporary tablespace, instead add more datafile to your temporary tablespace.
if you want to delete the temproray tablespace,
first make sure that your temporary tablespace is not used by any one.
create a new temporary tablespace.
change the temprorary tablespace for all the users you have assigned. ex: alter user <username> temporary tablsepace tts quota unlimited on tts.
i hope this solutiion will definetly help you out.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
