oracle表、序列创建和回滚

--tm_dtx5_config
create table tm_dtx5_config
(
  id               NUMBER(18) not null,
  delive_code      VARCHAR2(100),
  transit_code     VARCHAR2(4000),
  type             VARCHAR2(32),
  version_number   VARCHAR2(32),
  deadline         VARCHAR2(32),
  param_1          VARCHAR2(1000),
  param_2          VARCHAR2(1000),
  param_3          VARCHAR2(1000),
  param_4          VARCHAR2(1000),
  param_5          VARCHAR2(1000),
  param_6          VARCHAR2(1000),
  param_7          VARCHAR2(1000),
  param_8          VARCHAR2(1000),
  param_9          VARCHAR2(1000),
  param_10         VARCHAR2(1000),
  data_comment     VARCHAR2(1000),
  status           VARCHAR2(30),
  create_tm        DATE,
  DEAL_FLG         NUMBER(2)
);
-- Add comments to the table 
comment on table tm_dtx5_config
  is 'DTX5配置表';
-- Add comments to the columns 
comment on column tm_dtx5_config.id
  is 'SEQ_tm_dtx5_config';
comment on column tm_dtx5_config.delive_code
is '分中心代码';
comment on column tm_dtx5_config.transit_code
is '中转场代码';
comment on column tm_dtx5_config.type
is '类型';
comment on column tm_dtx5_config.version_number
is '版本号';
comment on column tm_dtx5_config.deadline
is '截止时间';
comment on column tm_dtx5_config.param_1
is '备用字段1';
comment on column tm_dtx5_config.param_2
is '备用字段2';
comment on column tm_dtx5_config.param_3
is '备用字段3';
comment on column tm_dtx5_config.param_4
is '备用字段4';
comment on column tm_dtx5_config.param_5
is '备用字段5';
comment on column tm_dtx5_config.param_6
is '备用字段6';
comment on column tm_dtx5_config.param_7
is '备用字段7';
comment on column tm_dtx5_config.param_8
is '备用字段8';
comment on column tm_dtx5_config.param_9
is '备用字段9';
comment on column tm_dtx5_config.param_10
is '备用字段10';
comment on column tm_dtx5_config.data_comment
is '备注';
comment on column tm_dtx5_config.status
  is '状态：有效0，无效1';
comment on column tm_dtx5_config.create_tm
  is '创建时间';
comment on column tm_dtx5_config.DEAL_FLG
  is '处理状态:未处理0，已处理2';
-- Create/Recreate primary, unique and foreign key constraints 
alter table tm_dtx5_config
  add constraint PK_tm_dtx5_config_ID primary key (id);
--创建tm_dtx5_config表的序列
-- Create sequence 
create sequence SEQ_tm_dtx5_config
minvalue 1
maxvalue 999999999999999999999
start with 1000
increment by 1
cache 20;

-- Create/Recreate indexes 
create index PK_TM_DTX5_CONFIG_DEAL_FLG on TM_DTX5_CONFIG (DEAL_FLG);


drop table tm_dtx5_config;
drop sequence SEQ_tm_dtx5_config;
drop index PK_TM_DTX5_CONFIG_DEAL_FLG;