Whittle Jerome Contr NCI,
1.Temporary tablespace in oracle8i+ does not need coalesce, and Oracle do not
deallocate used sort extents. This is a feature.
2.There is no pctincrease parameter in TEMPORARY tablespace.
SQL> /
create temporary tablespace test_tmp tempfile '/home/oracle/
Jerry,
It was just for update. True temporary tablespace cannot be created using
datafile(dictionery managed) but tempfile which is allowable by locally
managed tablespace. I just tried to create it with datafile but it gave me
error.
Here, on this list we are learning everyday something new
Title: RE: RE: Oracle TEMPORARY SEGMENT
Rafiq,
I'm not using locally managed tablespaces just yet. If the definition of 'truly temporary' includes locally managed tablespace, then you are correct.
Thanks for keeping me on the straight and narrow.
Jerry Whittle
A
Jerry,
Your sql will never run on Temp tablespace 'that are truly temporary' in
8.1.7
Just see the results
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production
SQL> alter tablespace temp default storage(pctincrea
Title: RE: RE: Oracle TEMPORARY SEGMENT
Hi,
It does work on temporary (that are truly temporary and not permanent) tablespaces in 7.3.4 and 8.1.7. I use it when I don't want to wait for SMON to clean things up. Just yesterday one our 'power users' ran SQL that selected from
Whittle Jerome Contr NCI,
I think your sql should not work on a really TEMPORARY tablespace, and
temporary tablespace do not need to be cleaned either.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
=== 2003-02-11 06:49:00 ,