Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP ! ! ! temp tablespace
I'm sure there are people out here with more up to date knowledge than mine, but I think the problem lies in that it is still looking for the original file. When you rename or drop a datafile you have to do this both from the database and then the operating system separately - in this order (or at least in Oracle 7.x.x you did). It wouldn't let you shutdown normal or immediate because it wanted to write to the datafile you'd moved before closing - each file records an internal counter, the SCN (system change number) used to keep them in step. By shutting down "abort" it skipped that but recorded that it needed recovery as a result. Presumably, on startup, it wasn't available to recover and you had to take it offline before opening? For now the proper fix eludes me, but as this is a temp tablespace you may be able to create a new temp tablespace to be going on with and at a convenient time perform a full database export then trash the old database, create afresh and perform a full import.
But it'd be worth waiting 24 hours for a response from someone with more recent DBA experience!
Regards
Mark
"ahmed kashif" <Ahmed_at_U.Arizona.Edu> wrote in message
news:971ll1$jvv$1_at_news.ccit.arizona.edu...
> my temp (temporary) tablespace grew to ~14g (dont know why it was set to
> unlimited?) - ended up taking all the disk space. I moved it to another
disk
> and brought it online, but then it wouldn't let me shutdown the database
> with the exception of shutdown abort. i tried to drop it with drop
> tablespace command, but it always seemed like it hung the database. i even
> let it go for hours - no luck. then i created a new tablespace 'temp2',
and
> made that tablespace the temporary tablespace for all the users. then i
> shutdown (abort) the database and removed that sucker from the filesystem.
> brought the database up with no problem. then i tried again to drop it
> throught drop tablespace, but it still does the same - hang the database
on
> me.
>
> i still can see that tablespace in dba_tablespaces, and i still can't
> shutdown normal or immediate. please HELP!!!
>
> --
>
>
> Thanks,
>
> ahmed
>
>
Received on Wed Feb 21 2001 - 20:00:21 CST