Re: Temp tablespace Database File Overgrown (20 Gigs)

Walt,

Next time, when creating a temporary tablespace, if you do set AUTOEXTEND to a nonzero value, make sure that you set the MAXSIZE to a sensible value (e.g. 4 GB).
Far better to have a runaway query fail on "unable to extend segment by 4096 bytes" than "unable to extend tempfile" and use all of the free space on that mount point.

At least this did not happen to a permanent tablespace.

If this temporary tablespace is the default temp tablespace for this database, you'll have to create a new temp tablespace and alter the database to use the new temp tablespace as the database default temp tablespace, prior to oracle permitting you to drop the huge temp tablespace.

btw - Oracle would not have allowed you to create permanent objects in a temporary tablespace in 9.2.

-bdbafh Received on Mon Apr 25 2005 - 18:08:07 CDT