Question about temporary tablespace

From: W. Scott Moore <sirws_at_hotmail.com>
Date: 2000/04/24
Message-ID: <_5%M4.390$r21.18972@news.uswest.net>#1/1

My temporary tablespace:

CREATE TABLESPACE TEMPORARY DATAFILE 'E:\Oracle\GPRO\Tmp1GPRO.ora' SIZE 200M DEFAULT STORAGE ( INITIAL 2m NEXT 2m MINEXTENTS 1 MAXEXTENTS 100 PCTINCREASE 0) TEMPORARY;
ALTER DATABASE DATAFILE 'E:\Oracle\GPRO\Tmp1GPRO.ora' AUTOEXTEND ON;

has grown from 200M to 1.3 GB (datafile size). I am not sure what would cause this. Maybe a large query or something?

In any case, is it possible to alter the tablespace offline, drop it, and recreate it? Or would this cause a problem?

Sincerely,
W. Scott Moore
City of Chandler, AZ Received on Mon Apr 24 2000 - 00:00:00 CDT