Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespaces - datafiles
Jared,
Same behaviuor on HP-UX version 11 with Oracle 8.1.7.2. Whatever size you define for tempfile , it is created with that size. Only observation that it is created much quicker than normal datafile of same size.
Regards
Rafiq
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Date: Tue, 11 Mar 2003 11:42:54 -0800
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 servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
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 servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
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 servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M Rafiq
INET: rafiq9857_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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). Received on Tue Mar 11 2003 - 14:01:27 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
![]() |
![]() |