Re: HELP ! ! ! temp tablespace

If you've got a legal copy, you probably have support - and that is the type of question for Oracle support. Also try http://technet.oracle.com discussion groups (actually monitored by support as well).

One of the things that may have botched you - you can't simply move a datafile - you have to 'alter tablespace rename datafile' (I don't remember exact syntax - sorry)

/Hans

ahmed kashif wrote:

> 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 Fri Apr 27 2001 - 08:52:39 CEST