PL/SQL Developer 工具导出表定义和数据

示例

Tools -> Exports Tables
User -> Name -> Output file

prompt PL/SQL Developer import file
prompt Created on 2022年5月21日 by WQ
set feedback off
set define off
prompt Creating SOE.LOGON_1...
create table SOE.LOGON_1
(
  logon_id    NUMBER not null,
  customer_id NUMBER not null,
  logon_date  DATE
)
tablespace SOE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 1M
    next 1M
    minextents 1
    maxextents unlimited
    pctincrease 0
  );



prompt Disabling triggers for SOE.LOGON_1...
alter table SOE.LOGON_1 disable all triggers;
prompt Loading SOE.LOGON_1...
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638386, 2751821, to_date('02-03-2006 09:19:11', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638445, 2439633, to_date('03-03-2001 02:27:19', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638483, 5672009, to_date('30-04-2011 22:47:52', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638568, 8358249, to_date('30-03-2004 09:39:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638576, 576315, to_date('18-03-2009 18:42:56', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638657, 9356729, to_date('03-02-2002 12:15:56', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638668, 6875543, to_date('14-03-2004 05:47:55', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638702, 3674171, to_date('23-03-2009 12:54:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638723, 5906142, to_date('25-11-2000 10:25:06', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638734, 7226813, to_date('17-01-2012 23:20:26', 'dd-mm-yyyy hh24:mi:ss'));
commit;
prompt 10 records loaded
prompt Enabling triggers for SOE.LOGON_1...
alter table SOE.LOGON_1 enable all triggers;
set feedback on
set define on
prompt Done.

只导出表和数据

prompt PL/SQL Developer import file
prompt Created on 2022年5月21日 by WQ
set feedback off
set define off
prompt Creating SOE.LOGON_1...
create table SOE.LOGON_1
(
  logon_id    NUMBER not null,
  customer_id NUMBER not null,
  logon_date  DATE
)
;

prompt Loading SOE.LOGON_1...
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638386, 2751821, to_date('02-03-2006 09:19:11', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638445, 2439633, to_date('03-03-2001 02:27:19', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638483, 5672009, to_date('30-04-2011 22:47:52', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638568, 8358249, to_date('30-03-2004 09:39:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638576, 576315, to_date('18-03-2009 18:42:56', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638657, 9356729, to_date('03-02-2002 12:15:56', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638668, 6875543, to_date('14-03-2004 05:47:55', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638702, 3674171, to_date('23-03-2009 12:54:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638723, 5906142, to_date('25-11-2000 10:25:06', 'dd-mm-yyyy hh24:mi:ss'));
insert into SOE.LOGON_1 (logon_id, customer_id, logon_date)
values (15638734, 7226813, to_date('17-01-2012 23:20:26', 'dd-mm-yyyy hh24:mi:ss'));
commit;
prompt 10 records loaded
set feedback on
set define on
prompt Done.