oracle环境搭建.doc

oracle环境搭建 rem rem $Header: summit2.sql 27-jun-2000.12:30:22 slari Exp $ rem rem Copyright (c) 1991, 2000 Oracle Corporation. All rights reserved. rem rem NAME rem summit2.sql - one-line expansion of the name rem DESCRIPTION rem short description of component this file declares/defines rem RETURNS rem rem FUNCTION rem Create and populate tables and sequences to support the Summit rem Sporting Goods business scenario. These objects and data are used rem in several Oracle classes and demonstration files. rem rem MODIFIED (MM/DD/YY) rem slari 06/27/00 - b1138912: remove duplicate contents rem mjaeger 07/14/99 - bug 808870: OCCS: convert tabs, no long lines rem GDURHAM Mar 15, 1993 -- Created set feedback off prompt Creating and populating tables and sequences. Please wait. rem Create sequences. rem Starting values for sequences begin at the existing maxima for rem existing primary key values, plus increments. CREATE SEQUENCE s_customer_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 216 NOCACHE NOORDER NOCYCLE; CREATE SEQUENCE s_dept_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 51 NOCACHE NOORDER NOCYCLE; CREATE SEQUENCE s_emp_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 26 NOCACHE NOORDER NOCYCLE; CREATE SEQUENCE s_image_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 1981 NOCACHE NOORDER NOCYCLE; CREATE SEQUENCE s_longtext_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 1369 NOCACHE NOORDER NOCYCLE; CREATE SEQUENCE s_ord_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 113 NOCACHE NOORDER NOCYCLE; CREATE SEQUENCE s_product_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 50537 NOCACHE NOORDER NOCYCLE; CREATE SEQUENCE s_region_id MINVALUE 1 MAXVALUE 9999999 INCREMENT BY 1 START WITH 6 NOC