LMT Concept seems fuzzy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: LMT Concept seems fuzzy

  1. #1
    Join Date
    Apr 2004
    Location
    chennai
    Posts
    9

    LMT Concept seems fuzzy

    I am using oracle9i which implies all my TS are LMT. I have executed the foll 3 commands.
    1)create tablespace ts1 datafile 'd:\ts1.dbf' size 5m default storage (initial 1m next 1m pctincrease 0);


    2)create tablespace ts2 datafile 'd:\ts2.dbf' size 5m default storage (initial 1m next 1m pctincrease 50);

    3)create tablespace ts3 datafile 'd:\ts1.dbf' size 5m default storage (initial 1m next 1m pctincrease 0) segment space management auto;

    select tablespace_name as 'TS_NAME', extent_management as 'EXT_MGT', segment_space_management 'SEG_MGT'
    from dba_tablespaces


    TS_NAME EXT_MGT SEG_MGT
    ------- ------- --------
    SYSTEM DICT MANUAL
    UNDO1 LOCAL MANUAL
    TEMP LOCAL MANUAL
    USERS LOCAL MANUAL
    TOOLS LOCAL MANUAL
    TS1 LOCAL MANUAL
    TS2 LOCAL MANUAL
    TS3 LOCAL AUTO

    I was of the opinion that storage settings in LMT is not allowed and also that segment space management for LMT is auto

    My Que:
    1)how come oracle didnt throw an error when initial,next and pct settings for an LMT were specified

    2)creation of tablespace 'ts3' i explicitly specified seg space mgt as auto. if u have LMT tablespace space related issues are tracked by bitmaps which means segment space managemt is auto for all LMT. Correct me if i am wrong.


    3) also if have table that has an LOB datatype is it necessary for this table to reside in dict managed tablespace.

    Just learing Database Administration, therefore please bear with such quereies

    Thanks
    Vijay
    Last edited by svijay21; 12-24-2004 at 11:11 AM.
    Thanks
    Vijay

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    ===
    My Que:
    1)how come oracle didnt throw an error when i initial,next and pct settings for an LMT

    2)creation of tablespace 'ts3' i explicitly specified seg space mgt as auto. if u have LMT tablespace space related issues are tracked by bitmaps which means segment space managemt is auto for all LMT. Correct me if i am wrong.


    3) also if have table that has an LOB datatype is it necessary for this table to reside in dict managed tablespace.

    Just learing Database Administration, therefore please bear with such quereies

    =====
    1. Oracle didn't error out if initial, next parameters are specified in the create tablespace statement. It just ignores.

    2. Yes

    3. It is optional. You can store LOB in inline or out-of-line.

    Tamil

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