So what was the problem then ?
"Glen A Stromquist" <glen_stromquist_at_no.spam.yahoo.com> a écrit dans le
message de news:lGqub.81481$jy.243_at_clgrps13...
> rpr wrote:
> > Hi,
> > In case Niall has not replied with details about his solution : Here
> > is what i think :
> >
> > 1) Put the temp files offline using : alter database datafile
> > '...<name> ' offline. You can use the file number here too but good
> > practice to stick to name.
> > 2) Open the database.
> > 3) Drop the temp tablespace
> > 4) CReate a new temp tablespace.
> >
> > If step 2 does not succeed because another file needs recovery then if
> > is a temp file then put it offline and try to open and so on. Of
> > course it is very important to make sure it is really temp. good luck
> >
> > Glen A Stromquist <glen_stromquist_at_nospam.yahoo.com> wrote in message
news:<K4Rtb.60065$jy.46712_at_clgrps13>...
> >
> >>Niall Litchfield wrote:
> >>
> >>
> >>>If it really is a temp tablespace (contents temporary) just drop and
> >>>recreate, there is nothing of value in it.
> >>>
> >>
> >>snipped
> >>
> >>I can't open the database to drop it, I'm tempted to shutdown the prod
> >>and just do a consistent cold backup and copy the whole works over and
> >>recreate the controlfile, but I'd like to know what went wrong here.
> >>
> >>btw - 8.1.7.4 on W2K advanced server, both at same patchset.
>
> thanks for the reply, I eventually got around it once I had a chance to
> think a little more clearly :-)
>
> cheers
>
Received on Tue Nov 18 2003 - 12:48:15 CST
