[oracle] pl/sql developer export user object

set define off
spool dataprocess.log

prompt
prompt Creating table C_LOGIC_TABLE
prompt ============================
prompt
create table DATAPROCESS.C_LOGIC_TABLE
(
  id                    VARCHAR2(50) not null,
  name                  VARCHAR2(100) not null,
  title                 VARCHAR2(100),
  status                CHAR(1) default '0',
  create_name           VARCHAR2(20),
  create_id             VARCHAR2(50),
  create_time           DATE,
  update_id             VARCHAR2(50),
  update_name           VARCHAR2(20),
  update_time           DATE,
  info_class            VARCHAR2(70),
  dept_id               VARCHAR2(50),
  dept_name             VARCHAR2(50),
  template_file_path    VARCHAR2(1000),
  cycle                 NUMBER(5),
  data_last_upload_time DATE
)
tablespace DATAPROCESSTS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table DATAPROCESS.C_LOGIC_TABLE
  is '???';
comment on column DATAPROCESS.C_LOGIC_TABLE.id
  is '??';
comment on column DATAPROCESS.C_LOGIC_TABLE.name
  is '????';
comment on column DATAPROCESS.C_LOGIC_TABLE.title
  is '??';
comment on column DATAPROCESS.C_LOGIC_TABLE.status
  is '?????????';
comment on column DATAPROCESS.C_LOGIC_TABLE.create_name
  is '?????';
comment on column DATAPROCESS.C_LOGIC_TABLE.create_id
  is '???id';
comment on column DATAPROCESS.C_LOGIC_TABLE.create_time
  is '????';
comment on column DATAPROCESS.C_LOGIC_TABLE.update_id
  is '???id';
comment on column DATAPROCESS.C_LOGIC_TABLE.update_name
  is '?????';
comment on column DATAPROCESS.C_LOGIC_TABLE.update_time
  is '????';
comment on column DATAPROCESS.C_LOGIC_TABLE.info_class
  is '???';
comment on column DATAPROCESS.C_LOGIC_TABLE.dept_id
  is '??id';
comment on column DATAPROCESS.C_LOGIC_TABLE.dept_name
  is '????';
comment on column DATAPROCESS.C_LOGIC_TABLE.template_file_path
  is '??????????????????';
comment on column DATAPROCESS.C_LOGIC_TABLE.data_last_upload_time
  is '??????????';
alter table DATAPROCESS.C_LOGIC_TABLE
  add primary key (ID)
  using index 
  tablespace DATAPROCESSTS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt
prompt Creating table BATCH_UPLOAD_HISTORY
prompt ===================================
prompt
create table DATAPROCESS.BATCH_UPLOAD_HISTORY
(
  id          VARCHAR2(50) not null,
  dept_id     VARCHAR2(50),
  table_id    VARCHAR2(50),
  file_name   VARCHAR2(100),
  file_path   VARCHAR2(1000),
  create_time DATE,
  user_id     VARCHAR2(50),
  status      NUMBER,
  upload_type NUMBER,
  dept_name   VARCHAR2(100)
)
tablespace DATAPROCESSTS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table DATAPROCESS.BATCH_UPLOAD_HISTORY
  add primary key (ID)
  using index 
  tablespace DATAPROCESSTS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table DATAPROCESS.BATCH_UPLOAD_HISTORY
  add constraint SYS_KKKKKK foreign key (TABLE_ID)
  references DATAPROCESS.C_LOGIC_TABLE (ID);

spool off