Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Setting quota on TEMP

    Does anyone set a quota on the TEMP tablespace for users? If so, is there a value that you start at and then work forwards?

    The concept of setting quotas on other tablespaces makes sense to me, but not on TEMP. I've been reading that the PGA, SGA (if using shared server) or TEMP tablespace could be used for sorting data for a user, and so I'm a bit confused on this topic.


  2. #2
    Join Date
    Jun 2004
    Liverpool, NY USA
    Tablespace quotas are not considered during temporary segment creation:
    * Temp segments DO NOT consume any quota that a user might possess.
    * Temp segments can be created in a tablespace for which a user does not have a quota.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts