On 7 Feb 2005 05:38:27 -0800, "Paul Izzo" <paul.izzo_at_mosca-ag.com>
wrote:
>This question is in reference to a Oracle 8i database. How can I tell
>as to which configuration I have for a current tablespace. I took a
>look into the scripts that created a tablespace and I can't determine
>if it's configured to use a dictionary or if it's locally managed.
>Here's the script:
>
>CREATE TABLE "W100"."PMLB" ("PMLBPHYS_AEND_IND" NUMBER(9) DEFAULT
> 0, "ARTIKEL_NR" VARCHAR2...
> USING INDEX
> TABLESPACE "W100_DATA"
> STORAGE ( INITIAL 104K NEXT 104K MINEXTENTS 1 MAXEXTENTS
> 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
> PCTFREE 10 INITRANS 2 MAXTRANS 255)
> TABLESPACE "W100_DATA" PCTFREE 10 PCTUSED 40 INITRANS 1
> MAXTRANS 255
> STORAGE ( INITIAL 8768K NEXT 104K MINEXTENTS 1 MAXEXTENTS
> 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
> LOGGING
select extent_management from dba_tablespaces where tablespace_name =
'W100_DATA'
Should list local or dictionary, the default is dictionary.
--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Feb 07 2005 - 07:59:25 CST
