DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ANOTHER LMT question

  1. 08-02-2001, 05:37 PM #1
    oracleman
    oracleman is offline Junior Member
    Join Date
    Apr 2001
    Location
    Berlin
    Posts
    65

    Cool

    Can I change the uniform extent size of an LMT tablespace?
    Assuming during the tablespace creation, I specified the uniform extent to be 8m.

    Later on I decided to change it to 64M. Is that possible.

    How does that affect teh tables in the tablespace. DO thier sizes change as well?
    Reply With Quote Reply With Quote
  2. 08-02-2001, 10:03 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    AFAIK, you can't change the extent size once you create the tablespace. You might be able to convert back to dictionary and then reconvert to LMT.
    Jeff Hunter
    Reply With Quote Reply With Quote
  3. 08-03-2001, 12:51 AM #3
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Marist can i covert a dictonary mnaged talbelspace to lmt?? is that possible.

    regards
    hrishy
    Reply With Quote Reply With Quote
  4. 08-03-2001, 02:16 AM #4
    ShrutiM's Avatar
    ShrutiM
    ShrutiM is offline Member
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    Unhappy

    Hi!!

    I may be unable to follow what is going on above, but
    when I change the value of Next Extent using
    DBA Studio it modifies the extent size of the tablespace

    Does the above discusion contradicts this.

    Regards
    Shruti
    Reply With Quote Reply With Quote
  5. 08-03-2001, 03:21 AM #5
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by hrishy
    Hello

    Marist can i covert a dictonary mnaged talbelspace to lmt?? is that possible.

    regards
    hrishy

    yes, use dbms_space_admin package
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width