oracle_catalogue_schema_header.sql 991 Bytes
Newer Older
1
2
CREATE SEQUENCE ARCHIVE_FILE_ID_SEQ
  INCREMENT BY 1
3
  START WITH 4294967296
4
  NOMAXVALUE
5
  MINVALUE 1
6
7
8
  NOCYCLE
  CACHE 20
  NOORDER;
9
10
11
12
13
14
15
16
CREATE SEQUENCE LOGICAL_LIBRARY_ID_SEQ
  INCREMENT BY 1
  START WITH 4294967296
  NOMAXVALUE
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER;
17
18
CREATE SEQUENCE STORAGE_CLASS_ID_SEQ
  INCREMENT BY 1
19
  START WITH 4294967296
20
21
22
23
24
  NOMAXVALUE
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER;
25
26
27
28
29
30
31
32
CREATE SEQUENCE TAPE_POOL_ID_SEQ
  INCREMENT BY 1
  START WITH 4294967296
  NOMAXVALUE
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER;
33
CREATE GLOBAL TEMPORARY TABLE TEMP_TAPE_FILE_INSERTION_BATCH(
34
  VID                   VARCHAR(100),
35
36
37
  FSEQ                  UINT64TYPE  ,
  BLOCK_ID              UINT64TYPE  ,
  LOGICAL_SIZE_IN_BYTES UINT64TYPE  ,
38
  COPY_NB               UINT8TYPE   ,
39
40
  CREATION_TIME         UINT64TYPE  ,
  ARCHIVE_FILE_ID       UINT64TYPE    
41
42
43
)
ON COMMIT DELETE ROWS;
CREATE INDEX TEMP_T_F_I_B_ARCHIVE_FILE_ID_I ON TEMP_TAPE_FILE_INSERTION_BATCH(ARCHIVE_FILE_ID);