 | | | drop temp tablespace | drop temp tablespace 2004-02-17 - By David Boyd
Hi List,
Our TEMP tablespace took Oracle default setting that was auto extending up
to 32 GB. Last week the tablespace had grown to 18 GB. I tried to drop the
tablespace after I removed any body 's temporary tablespace to a newly
created temp tablespace with much smaller size. The dropping process is
very slow. I started last Friday. The used size in the old temp tablespace
had been decreased from 18 GB to 3.8 GB yesterday afternoon. I issued the
drop command through TOAD job scheduler. There was one failure with the job
when I checked this morning. The dropping process seemed stopped. I had to
kill the job. Now the used size in the old temp tablespace is coming back
slowly even through I issued another dropping command in SQLPLUS. I was
wondering if any one has any way to drop the temp tablespace quickly.
Thanks in advance.
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Find and compare great deals on Broadband access at the MSN High-Speed
Marketplace. http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|