-
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
-
===
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|