MEDIK_TABLE_LOADER.SQL
-- DROP PUBLIC SYNONYM MLO_LO10_DATA_LOADER;
-- DROP TABLE LO10_DATA_LOADER;
CREATE TABLE LO10_DATA_LOADER
( DATA VARCHAR2(1024),
ZDROJ VARCHAR2(128) NOT NULL,
uzivatel VARCHAR2(30) NOT NULL,
DATUM DATE NOT NULL
)
TABLESPACE MEDIK STORAGE (initial 32M next 16M);
CREATE INDEX LO10_DATA_LOADER_I0
ON LO10_DATA_LOADER (ZDROJ ASC, DATA)
TABLESPACE MEDIK STORAGE ( initial 24M next 16M);
CREATE INDEX LO10_DATA_LOADER_I1
ON LO10_DATA_LOADER (DATA ASC, ZDROJ)
TABLESPACE MEDIK STORAGE ( initial 24M next 16M);
CREATE INDEX LO10_DATA_LOADER_I2
ON LO10_DATA_LOADER (ZDROJ ASC)
TABLESPACE MEDIK STORAGE ( initial 8M next 8M);
CREATE PUBLIC SYNONYM MLO_LO10_DATA_LOADER FOR LOADER.LO10_DATA_LOADER;