Hi,
Well I can think of situations where you might want a tablespace as a users
temporary ts, that can hold permanent objects, but in general I agree that
this ts should be temporary. Also I would advise you to use a tempfile
temporary tablespace, created with the "create temporary tablespace xxx
tempfile '...';" syntax. This type of temp tablespace is locally managed and
avoids the overhead of dictionary changes when allocating extents.

Regards

Pete

[END]


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************
Oracle LazyDBA home page