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: TEMP tablespace little problem

Re: TEMP tablespace little problem

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 20 Nov 2003 12:29:51 -0800
Message-ID: <1069360217.662713@yasure>


Noel wrote:

> Hello everyone!.
> I'm rarely posting my oracle-troubles here but, but..
> I've done some big ugly and nasty thingies to my personal 8.1.7 Oracle
> Server run on Win2000 Sp4.
> I can magage reinstalling everything, but im short of time.
> One day i noticed that ORA-00600, but it happened when i was starting big
> sql queries, or was calculating
> statistics on huge tables.
> I noticed, that my database had always problems when a datafile exeed over
> 2G size.
> Don't know, maybe i screwed something with Win2k instalation or something.
> I noticed, that TEMP tablespace got datafile over 2,5G so i tried to shrink
> it.
> After succesful resize to 500M, the file associated with tablespace still
> had 2,5G...
> And now what i've done:
> I created the 2nd file for that tablespace, putted TEMP offline removed
> that 2,5G file from file system and end in a mess.
> TEMP couldn't go online.
> I try to set TEMP2 tablespace and will move all users and their temporary
> tablespace to this TEMP2.
> But im wonder if i could restore my orginal TEMP while file temp01.dbf is
> missing.
> Database works fine until i log and try to do any sql statetment :-)
>
> --
> Noel

And you have patched to 8.1.7.4?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Nov 20 2003 - 14:29:51 CST

Original text of this message

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