values (195, 194, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (199, 197, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (199, 198, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (203, 201, '2', 1, 70000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (203, 202, '7', 3, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (208, 207, '7', 7, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (208, 206, '4', 4, 400);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (242, 240, '1', 1, 300);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (242, 241, '7', 1, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (245, 244, '7', 2, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (263, 262, '4', 1, 400);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (266, 265, '4', 1, 400);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (269, 268, '7', 1, 2000);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (272, 271, '3', 1, 300);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (275, 274, '3', 1, 300);
insert into LINEITEM (ORDERID, LINENUM, ITEMID, QUANTITY, LISTPRICE)
values (278, 277, '3', 1, 300);
commit;
prompt 67 records loaded
prompt Loading ORDERSTATUS...
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (95, to_date('15-03-2008 09:06:49', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (99, to_date('15-03-2008 09:14:23', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (103, to_date('15-03-2008 09:21:21', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (107, to_date('15-03-2008 09:23:52', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (111, to_date('15-03-2008 09:27:48', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (115, to_date('15-03-2008 09:28:34', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (119, to_date('15-03-2008 09:29:52', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (123, to_date('15-03-2008 09:30:55', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (127, to_date('15-03-2008 09:31:56', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (131, to_date('15-03-2008 09:32:25', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (135, to_date('15-03-2008 09:32:42', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (139, to_date('15-03-2008 09:33:47', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (143, to_date('15-03-2008 09:34:01', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (147, to_date('15-03-2008 09:37:37', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (151, to_date('15-03-2008 09:38:28', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (155, to_date('15-03-2008 09:38:50', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (159, to_date('15-03-2008 09:39:16', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (163, to_date('15-03-2008 09:39:39', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (167, to_date('15-03-2008 09:41:21', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (171, to_date('15-03-2008 09:41:44', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (175, to_date('15-03-2008 09:43:14', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (179, to_date('15-03-2008 09:46:46', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (183, to_date('15-03-2008 09:47:22', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (187, to_date('15-03-2008 09:47:38', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (191, to_date('15-03-2008 09:48:20', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (195, to_date('15-03-2008 09:48:42', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (199, to_date('15-03-2008 09:49:26', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (203, to_date('15-03-2008 09:50:07', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (208, to_date('15-03-2008 09:55:58', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (242, to_date('15-03-2008 10:18:48', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (245, to_date('15-03-2008 10:30:32', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (263, to_date('15-03-2008 13:36:28', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (266, to_date('15-03-2008 13:36:41', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (269, to_date('15-03-2008 13:38:06', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (272, to_date('15-03-2008 14:18:40', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (275, to_date('15-03-2008 14:20:27', 'dd-mm-yyyy hh24:mi:ss'), '1');
insert into ORDERSTATUS (ORDERID, TIMESTAMP, STATUS)
values (278, to_date('15-03-2008 14:20:58', 'dd-mm-yyyy hh24:mi:ss'), '1');
commit;
prompt 37 records loaded
prompt Loading PROFILE...
insert into PROFILE (USERID, LANGPREF, FAVCATEGORY, MYLISTOPT, BANNEROPT)
values ('2', 'chinese', '狗', null, null);
insert into PROFILE (USERID, LANGPREF, FAVCATEGORY, MYLISTOPT, BANNEROPT)
values ('204', 'chinese', '狗', null, null);
commit;
prompt 2 records loaded
prompt Loading SEQUENCE...
prompt Table is empty
prompt Enabling foreign key constraints for ACCOUNT...
alter table ACCOUNT enable constraint FK_ACCOUNT_A_SIGNON;
prompt Enabling foreign key constraints for PRODUCT...
alter table PRODUCT enable constraint FK_PRODUCT_FK_PRODUC_CATEGORY;
prompt Enabling foreign key constraints for ITEM...
alter table ITEM enable constraint FK_ITEM_FK_ITEM_1_PRODUCT;
alter table ITEM enable constraint FK_ITEM_FK_ITEM_2_SUPPLIER;
prompt Enabling foreign key constraints for INVENTORY...
alter table INVENTORY enable constraint FK_INVENTOR_RELATIONS_ITEM;
prompt Enabling foreign key constraints for ORDERS...
alter table ORDERS enable constraint FK_ORDERS_FK_ORDERS_ACCOUNT;
prompt Enabling foreign key constraints for LINEITEM...
alter table LINEITEM enable constraint FK_LINEITEM_FK_LINEIT_ORDERS;
alter table LINEITEM enable constraint FK_LINEITEM_RELATIONS_ITEM;
prompt Enabling foreign key constraints for ORDERSTATUS...
alter table ORDERSTATUS enable constraint FK_ORDERSTA_FK_ORDERS_ORDERS;
prompt Enabling foreign key constraints for PROFILE...
alter table PROFILE enable constraint FK_PROFILE_B_SIGNON;
prompt Enabling triggers for SIGNON...
alter table SIGNON enable all triggers;
prompt Enabling triggers for ACCOUNT...
alter table ACCOUNT enable all triggers;
prompt Enabling triggers for BANNERDATA...
alter table BANNERDATA enable all triggers;
prompt Enabling triggers for CATEGORY...
alter table CATEGORY enable all triggers;
prompt Enabling triggers for PRODUCT...
alter table PRODUCT enable all triggers;
prompt Enabling triggers for SUPPLIER...
alter table SUPPLIER enable all triggers;
prompt Enabling triggers for ITEM...
alter table ITEM enable all triggers;
prompt Enabling triggers for INVENTORY...
alter table INVENTORY enable all triggers;
prompt Enabling triggers for ORDERS...
alter table ORDERS enable all triggers;
prompt Enabling triggers for LINEITEM...
alter table LINEITEM enable all triggers;
prompt Enabling triggers for ORDERSTATUS...
alter table ORDERSTATUS enable all triggers;
prompt Enabling triggers for PROFILE...
alter table PROFILE enable all triggers;
prompt Enabling triggers for SEQUENCE...
alter table SEQUENCE enable all triggers;
set feedback on
set define on
prompt Done.