RE: Tablespaces - datafiles

  I think the docs must be talking about the fact that the files are created as sparse files. With sparse files you will get the same behavior. I have never noticed them being created smaller than the specified size.

Regards,
Denny

Quoting Jared.Still_at_radisys.com:

> Tom,
>
> Do you have that doc ref handy?
>
> Using this SQL:
>
> create temporary tablespace temp3 tempfile '/u01/oradata/dv03/temp3.dbf'
>
> size 500m
> extent management local uniform size 1m
> /
>
> On both 8.1.7.0 and 9.2.0.1 on RH 7.2 I found that the file was
> immediately created full size.
>
> Platform dependencies maybe?
>
> Jared
>
>
>
>
>
>
> "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
> Sent by: root_at_fatcity.com
> 03/11/2003 06:19 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: Tablespaces - datafiles
>
>
> LeRoy,
>
> I just struggled with this last week. You can't move Temporary Data
> files.
> You need to drop and recreate the TEMP tablespace - creating the data
> files
> in the correct directories.
>
> On a side note - here is an interesting feature. When Oracle creates
> files
> for the TEMP tablespace, it does not create the files full sized like
> it
> does for normal data files. It creates them smaller for speed purposes
>
> (it
> creates the TEMP tablespace very fast) and will allow the TEMP data
> files
> to
> grow as needed.
>
> Now here is the kicker. Let's say you have a disk that is 9 gig is
> size.
> You can create 10-1 Gig Temp data files on that disk. Since Oracle does
>
> not
> create the files full-sized, there is nothing to stop this from
> happening.
> Sometime later, as the TEMP tablespace gets used, the files grow until
> eventually the disk fills up, and a sql query crashes with an obscure
> disk
> io error. Oracle is trying to expand the TEMP datafiles to the size
> it's
> been told they should be. But there is no physical space left on
> disk.
>
> Documentation in 817 does not mention this. But 92 doc's are up to
> date.
>
> nice surprise, eh?
>
> Tom Mercadante
> Oracle Certified Professional
>
>
> -----Original Message-----
> Sent: Tuesday, March 11, 2003 8:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> All -
>
> I am having a problem with the datafiles in a temporary tablespace. I
> need to move and rename three different datafiles in the tablespace.
> I
> am able to take them offline - no problem. I cna make the changes at
> the OS level. I am running on Unix. But I can't get the changes to
> show up in the OEM inorder to bring them back on-line.
>
> Do I need to remove all users from this tablespace before making these
> changes? The tablespace is temporary so does that make a difference?
> Any suggestions?
>
> LeRoy
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: LeRoy Kemnitz
> INET: lkemnitz_at_uwsa.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mercadante, Thomas F
> INET: NDATFM_at_labor.state.ny.us
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Denny Koovakattu
  INET: groups_at_koovakattu.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).