1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| PROMPT CREATE TABLE G2_assoc_class_event
CREATE TABLE G2_assoc_class_event
(
CLIENT_ID NUMBER (10) NOT NULL
, TABLE_NAME VARCHAR2 (30) NOT NULL
, CONSTRAINT G2_PK_ASSOC_CLASS_EVENT PRIMARY KEY (CLIENT_ID, TABLE_NAME)
USING INDEX
PCTFREE 10 INITRANS 2
STORAGE ( INITIAL &&VAR_STO_INIT_SMALL NEXT &&VAR_STO_NEXT_SMALL MINEXTENTS 1 PCTINCREASE 0 BUFFER_POOL KEEP )
TABLESPACE &&VAR_TABLE_TS
)
PCTFREE 20 PCTUSED 70 INITRANS 1
STORAGE ( INITIAL &&VAR_STO_INIT_SMALL NEXT &&VAR_STO_NEXT_SMALL MINEXTENTS 1 PCTINCREASE 0 BUFFER_POOL KEEP )
TABLESPACE &&VAR_TABLE_TS;
PROMPT ALTER TABLE G2_ASSOC_CLASS_EVENT ADD CONSTRAINT G2_FK_AC_CLIENT_ID FOREIGN KEY ( CLIENT_ID )
ALTER TABLE G2_ASSOC_CLASS_EVENT ADD CONSTRAINT G2_FK_AC_CLIENT_ID FOREIGN KEY ( CLIENT_ID )
REFERENCES G2_EVENT_LISTENER ( CLIENT_ID ); |
Partager