Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace, Diskspace or sql abuse..
"Ryan Gaffuri" <rgaffuri_at_cox.net> wrote in message
news:1efdad5b.0306241036.5ec79048_at_posting.google.com...
> by 'tempfile' you mean a locally managed temporary tablespace correct?
Not exactly, he means tablespaces created with the command
create temporary tablespace blah
TEMPfile 'temp01.dbf' size 1049m;
Its the specification of the datafile rather than the extent management clause that is important.
> this doesnt happen with dictionary managed temporary tablespaces. This
> is pretty interesting. Never saw that before.
IIRC it does or could happen with DMT's. Unfortunately I don't have a DMT system to play with at home to prove it. This is probably a bit daft. Try the following (on an 8i instance)
create temporary tablespace blah
tempfile 'blah.dbf' size 10m;
followed by
select extent_management from dba_tablespaces where tablespace_name='BLAH';
should prove you can have a dictionary managed sparse file.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Tue Jun 24 2003 - 15:40:37 CDT