1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
CREATE TABLE "DBO"."P_DESG"
( "DSG_AG_GESTION" NUMBER(5,0) NOT NULL ENABLE,
"DSG_DOMAINE_APPLI" VARCHAR2(8 CHAR) NOT NULL ENABLE,
"DSG_NO_CPTE_GENERAL" NUMBER(10,0) NOT NULL ENABLE,
"DSG_NO_ETAB_NAISS" NUMBER(5,0) NOT NULL ENABLE,
"DSG_NO_PERS" NUMBER(10,0) NOT NULL ENABLE,
"DSG_NO_CPTE_AUXIL" NUMBER(5,0) NOT NULL ENABLE,
"DSG_NO_ETAB_NAIS" NUMBER(5,0) NOT NULL ENABLE,
"DSG_NO_IMMEUBLE" NUMBER(5,0) NOT NULL ENABLE,
"DSG_NO_LOT" VARCHAR2(5 CHAR) NOT NULL ENABLE,
"DSG_VALEUR_DESCRIPTIF" VARCHAR2(200 CHAR),
"DSG_VALEUR_MEMO" VARCHAR2(500 CHAR),
"DSG_ACTIVITE" VARCHAR2(2 CHAR) NOT NULL ENABLE,
"DSG_AGGEST" NUMBER(10,0) NOT NULL ENABLE,
"DSG_MANDAT" NUMBER(10,0) NOT NULL ENABLE,
"DSG_NIU" FLOAT(126) NOT NULL ENABLE,
"NO_DOSS_TRX" NUMBER(10,0) NOT NULL ENABLE,
CONSTRAINT "DSG_AUX_IMM" PRIMARY KEY ("DSG_NO_IMMEUBLE", "DSG_NO_LOT", "DSG_NIU", "DSG_AGGEST", "DSG_MANDAT", "NO_DOSS_TRX", "DSG_AG_GESTION", "DSG_DOMAINE_APPLI", "DSG_NO_CPTE_GENERAL", "DSG_NO_ETAB_NAISS", "DSG_NO_PERS", "DSG_NO_CPTE_AUXIL", "DSG_NO_ETAB_NAIS")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 91226112 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 72351744 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "DBO"."DSG_AUX_IMM" ON "DBO"."P_DESG" ("DSG_NO_IMMEUBLE", "DSG_NO_LOT", "DSG_NIU", "DSG_AGGEST", "DSG_MANDAT", "NO_DOSS_TRX", "DSG_AG_GESTION", "DSG_DOMAINE_APPLI", "DSG_NO_CPTE_GENERAL", "DSG_NO_ETAB_NAISS", "DSG_NO_PERS", "DSG_NO_CPTE_AUXIL", "DSG_NO_ETAB_NAIS")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 91226112 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
CREATE INDEX "DBO"."DSG_DOMAINE" ON "DBO"."P_DESG" ("DSG_AG_GESTION", "DSG_DOMAINE_APPLI", "DSG_NIU")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 48234496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
CREATE INDEX "DBO"."DSG_MANDAT" ON "DBO"."P_DESG" ("DSG_AG_GESTION", "DSG_ACTIVITE", "DSG_MANDAT", "NO_DOSS_TRX")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 40894464 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ; |
Partager