Re: dba_free_space missing a tablespace???

Kyle, I'm happy to clarify, so long as you don't start spouting rubbish about what proper temporary tablespace is.

In 8i, it is perfectly legitimate to create 'old fashioned' temporary tablespace with the 'create tablespace blah ... temporary' commands that were alive and kicking in versions 7 and 8. And such tablespace is as temporary as the kind you create using the 'create temporary tablespace tempfile 'x'' command that was introduced in 8i.

Or are you claiming that Oracles 7 and 8 didn't have proper temporary tablespaces?

The correct distinction to be drawn is between tempfiles and datafiles. And tempfiles don't show up in free_space. Datafiles do. And to say that "temporary tablespace" doesn't appear is therefore simply incorrect, since temporary tablespace can use datafiles.

Regards
HJR <hailey_kyle_at_my-deja.com> wrote in message news:94r649$1n4$1_at_nnrp1.deja.com...
> Very interesting - your clarifications are GREAT, but I'm not sure why
> you started off your email with such a misleading comment as:
>
> >>Temporary tablespace most certainly DOES show up in dba_free_space
>
> Temporary tablespaces do NOT show up in dba_free_space. A temporary
> tablespace is the following:
>
> create temporary tablespace ...
>
> Now you can create a tablespace whose contents are temporary as in:
>
> create tablespace foo ...
> alter tablespace temporary ...
>
> this is a normal tablespace that contents are considered temporary. Not
> the same thing. Creating a temporary tablespace creates the tablespace
> as nologging, locally managed and temporary. Altering a tablespace
> temporary only changes the content type. It doesn't set the nologging
> or locally managed (of course making a data dictionary tbs into a
> locally managed would be a pain). Try to create a locally managed
> tablespace and alter temporary and you get ora-03218, as you have found.
>
>
> Best
> Kyle
>
Received on Fri Jan 26 2001 - 03:48:58 CST