How many temp-ts are possible ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How many temp-ts are possible ?

  1. #1
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    How many temp-ts are possible ?

    Oracle9i EE

    Hi,
    is it possible to have more then on temp-tablspace?
    Regards
    Orca

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi,
    no restriction except max number of tablespaces per database (64K for 8i seems to be enough) and the DB_FILES parameter.
    However, it's pointless to have more temp tablespaces than users, I think.
    Ales
    The whole difference between a little boy and an adult man is the price of toys

  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Thanks ales
    Orca

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by ales
    Hi,
    no restriction except max number of tablespaces per database (64K for 8i seems to be enough) and the DB_FILES parameter.
    However, it's pointless to have more temp tablespaces than users, I think.
    You can have at most 65533 files in 9i DBs. May be less on some operating systems. It is limited also by size of database blocks and by the DB_FILES.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

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


Click Here to Expand Forum to Full Width