oracle中表、主鍵、索引都有存貯數(shù)屬性,

? tablespace TTTS
? pctfree 10
? initrans 2
? maxtrans 255
? storage
? (
??? initial 64K
??? minextents 1
??? maxextents unlimited
? );

索引它們都是被實(shí)實(shí)在在存在磁盤中。而外鍵、視圖等都沒(méi)有存貯屬性，只是被記錄在oracle的后臺(tái)表中而已。

?

-- Create table
create table CERTTYPE
(
? CERTTYPEID???????? NUMBER(3) not null,
? CERTTYPENAME?????? VARCHAR2(30) not null,
? RIGHTTYPEID??????? NUMBER(3),
? CERTPRENAME??????? VARCHAR2(20),
? CERTPRENAMESOURCE? VARCHAR2(200),
? CERTPRENAMESUFFIX? VARCHAR2(20),
? CERTPOSTWORDSOURCE VARCHAR2(200),
? CERTPOSTWORDSUFFIX VARCHAR2(20),
? CERTPOSTIDPREFIX?? VARCHAR2(20),
? CERTPOSTIDSOURCE?? VARCHAR2(200),
? CERTPOSTIDCODERULE NUMBER(1) default 1 not null,
? CERTPOSTIDLENGTH?? NUMBER(2) default 6 not null,
? CERTPOSTIDSUFFIX?? VARCHAR2(20),
? PARENTCERTTYPEID?? NUMBER(3),
? CERTPOSTIDSTARTID? NUMBER(12) default 1 not null,
? READONLY?????????? NUMBER(1) default 0 not null
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CERTTYPE
? add constraint PK_CERTTYPE primary key (CERTTYPEID);
alter table CERTTYPE
? add constraint FK_CERTTYPE_RIGHTTYPE foreign key (RIGHTTYPEID)
? references RIGHTTYPE (RIGHTTYPEID);
alter table CERTTYPE
? add constraint FK_CERTTYPE_SELF foreign key (PARENTCERTTYPEID)
? references CERTTYPE (CERTTYPEID) on delete set null;
-- Create/Recreate indexes
create index IDX_CERTTYPE_PARENTCERTTYPEID on CERTTYPE (PARENTCERTTYPEID);
create index IDX_CERTTYPE_RIGHTTYPEID on CERTTYPE (RIGHTTYPEID);

oracle pl/sql 中表的創(chuàng)建