-- Create table 链路表
create table NEMGR.TBL_LINK
(
LINKNAME VARCHAR2(600),
ANEDN VARCHAR2(100) not null,
APORTDN VARCHAR2(100) not null,
ZNEDN VARCHAR2(100) not null,
ZPORTDN VARCHAR2(100) not null,
LINKSTATUS NUMBER(10) not null,
LINKTYPE NUMBER(10) not null,
LINKNAMEALIAS VARCHAR2(600),
SPEED VARCHAR2(10),
APORTIP VARCHAR2(64),
ZPORTIP VARCHAR2(64),
LINKDN VARCHAR2(600) not null,
LINKUSEDSTATUS VARCHAR2(20) not null
)
tablespace NEMGRDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create unique index NEMGR.TBL_LINK_INDEX on NEMGR.TBL_LINK (LINKDN)
tablespace NEMGRDB
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create table NEMGR.TBL_LINK
(
LINKNAME VARCHAR2(600),
ANEDN VARCHAR2(100) not null,
APORTDN VARCHAR2(100) not null,
ZNEDN VARCHAR2(100) not null,
ZPORTDN VARCHAR2(100) not null,
LINKSTATUS NUMBER(10) not null,
LINKTYPE NUMBER(10) not null,
LINKNAMEALIAS VARCHAR2(600),
SPEED VARCHAR2(10),
APORTIP VARCHAR2(64),
ZPORTIP VARCHAR2(64),
LINKDN VARCHAR2(600) not null,
LINKUSEDSTATUS VARCHAR2(20) not null
)
tablespace NEMGRDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create unique index NEMGR.TBL_LINK_INDEX on NEMGR.TBL_LINK (LINKDN)
tablespace NEMGRDB
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);