示例
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.