Re: Temporary tablespaces

This response was emailed to the author

Hi,

    You can always do:

    ALTER USER big_query TEMPORARY TABLESPACE new_space QUOTA UNLIMITED ON new_space;

regards
Jerry Gitomer

1. López wrote in message <7np4dj$ghu$1_at_talia.mad.ttd.net>...
   |Hi,
   |
   |I am learning Oracle and I'd like to know if it was interesting
   to have more
   |than one temporary tablespace if I have only one user who make a
   lot of
   |complex queries.
   |
   |
   |Thanks in advance, A.Lopez
   |
   |