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
Received on Mon Feb 07 2005 - 07:38:27 CST
