locally managed tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: locally managed tablespaces

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    Talking

    I have 2 related questions, can any one help?

    QUES1. IS the default maxsize for an LMT 2048M?

    QUES2. Does the maxsize mean the same as max_extents in
    that of a dictionary managed tablespace?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    1. don't know for sure, but I would bet it is platform dependant.

    2. maxsize is the maximum size your data file can grow to. maxsize is not specific to LMT's, but AUTOEXTEND.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2001
    Posts
    157
    Good looking out.

    DO you have any opinion on this?

    Is it a good practise to specify the maxsize in your cretae LMT
    command even if you want the maxsize to use the default value
    for the operating system?
    I am thinking of not specifying the maxsize so that it uses the
    default value based on my O/S, but I'm not sure if this is a
    good practise

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Sure you can do so...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    AUTOEXTEND should be avoided if using raw files/partitions.



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