SQL-Vorlage: organization index
Für Index-organisierte Tabelle nutze ich folgende Vorlage:
create table D_ZI_PSEUDO
(
ZI_DATEN_JAHR number (4) not null
, D_ZI_PSEUDO_KEY number generated always as identity not null
, VS_NUMMER varchar2 (40 char) not null
, ZI_PSEUDO_JAHR number (4) not null
, INS_PROCESS_KEY number not null
, INS_DATE date not null
, constraint D_ZI_PSEUDO_PK primary key (ZI_DATEN_JAHR, D_ZI_PSEUDO_KEY)
, constraint D_ZI_PSEUDO_UK1 unique (ZI_DATEN_JAHR, VS_NUMMER) using index local
)
organization index
tablespace MY_DATA
logging
partition by list (ZI_DATEN_JAHR)
(partition P_0 values (0) logging nocompress tablespace MY_DATA)
nocompress
monitoring;
create table D_ZI_PSEUDO
(
ZI_DATEN_JAHR number (4) not null
, D_ZI_PSEUDO_KEY number generated always as identity not null
, VS_NUMMER varchar2 (40 char) not null
, ZI_PSEUDO_JAHR number (4) not null
, INS_PROCESS_KEY number not null
, INS_DATE date not null
, constraint D_ZI_PSEUDO_PK primary key (ZI_DATEN_JAHR, D_ZI_PSEUDO_KEY)
, constraint D_ZI_PSEUDO_UK1 unique (ZI_DATEN_JAHR, VS_NUMMER) using index local
)
organization index
tablespace MY_DATA
logging
partition by list (ZI_DATEN_JAHR)
(partition P_0 values (0) logging nocompress tablespace MY_DATA)
nocompress
monitoring;
Kommentare
Kommentar veröffentlichen