local extents on all tablespaces except SYSTEM ????
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: local extents on all tablespaces except SYSTEM ????

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    on our database, should we use local extents on all tablespace except SYSTEM tablespace ???

    Another word, should we use local extent for rollback tablespace, temp and all of the database files ???

    Thanks'

  2. #2
    Join Date
    May 2002
    Posts
    42
    start with TEMP as locally managed.

    for the other tablespaces use extent managment that makes sence for the objects they will store.

  3. #3
    Join Date
    Jan 2002
    Posts
    474
    I am not clear of what you are trying to say. Are you saying that I should use TEMP tablespace with LOCAL EXTENT??? what about ROLLBACK tablespace ???

    thanks

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dont use LMT with RBS, there are several bugs unless they are fixed in 8.1.7.4

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by pando
    dont use LMT with RBS, there are several bugs unless they are fixed in 8.1.7.4
    That's true. And 8.1.7.4 will be BTW the last patch set for 8.1.7.
    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