To perform sorts, Oracle use the temporary tablespace specified for each
user (check view dba_users). Normally, all users must point to the same
temporary tablespace. You can correct the situation without introducing new
problem by creating a new tablespace "temp" and by adjusting every user to
point temporary tablespace on "temp".
jbmorlaATcalva.net a écrit dans le message
<79044k$gtq$1_at_guinness.serv.psi.calva.net>...
>Hi
>I just inherited a system without temporary tablespace. So where does
oracle
>do all the sorts?
>
>
Received on Sat Jan 30 1999 - 22:22:35 CST
