复制CREATE TABLE trbtkt.tickets ( tkt_idNUMBER ,中何description VARCHAR2(30) ,submit_dtm TIMESTAMP ,statusVARCHAR2(8) ,document BLOB ,scrnimg BLOB ) LOB(document) STORE AS BASICFILE (TABLESPACE basicfiles) ,LOB(scrnimg) STORE AS BASICFILE (TABLESPACE basicfiles) PARTITION BY LIST (status) ( PARTITION sts_open VALUES (OPEN) ,PARTITION sts_pending VALUES (PENDING) ,PARTITION sts_closed VALUES (CLOSED) ,PARTITION sts_other VALUES (DEFAULT) ) ;

--注释 COMMENT ON TABLE trbtkt.tickets IS Contains Trouble Ticket transaction data; COMMENT ON COLUMN trbtkt.tickets.tkt_id IS Unique identifier for a Trouble Ticket; COMMENT ON COLUMN trbtkt.tickets.description IS Trouble Ticket Description; COMMENT ON COLUMN trbtkt.tickets.submit_dtm IS Trouble Ticket Submission Time Stamp; COMMENT ON COLUMN trbtkt.tickets.status IS Trouble Ticket Status; COMMENT ON COLUMN trbtkt.tickets.document IS Large Object (LOB) that contains a Microsoft Word document that provides detailed information about a Trouble Ticket; COMMENT ON COLUMN trbtkt.tickets.scrnimg IS Large Object (LOB) that contains a screen print or other image that helps a problem solver identify how to act on a Trouble Ticket;

-- 创建索引和约束 CREATE UNIQUE INDEX trbtkt.tickets_pk_idx ON trbtkt.tickets(tkt_id) TABLESPACE users;

ALTER TABLE trbtkt.tickets ADD CONSTRAINT tickets_pk PRIMARY KEY (tkt_id);

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.48.49.50.51.52.53.54.55.56.57.

(责任编辑：IT科技)