Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace, Diskspace or sql abuse..

Re: Tablespace, Diskspace or sql abuse..

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 24 Jun 2003 21:40:37 +0100
Message-ID: <3ef8b6ef$0$10623$cc9e4d1f@news.dial.pipex.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US