Edit D:\libsystem.dmp
TEXPORT:V11.02.00 DJISHEN1 RUSERS 2048 0 64 0 Tg? ??? 6? 22 17:20:16 2018c:/mdb20180622.dmp d `$ #G###A?# ?g? d `$ #G###A?# ?TT +00:00 BYTE UNUSED 2 INTERPRETED DISABLE:ALL METRICSU METRICSUre-schema ??????? PROCACTION ? BEGIN ? sys.dbms_logrep_imp.instantiate_schema(schema_name=>SYS_CONTEXT('USERENV','CURRENT_SCHEMA'), export_db_name=>'ILAS', inst_scn=>'7901576'); COMMIT; END; METRICEU 17 METRICSU? ??????? METRICEU 17 METRICSUC ????? METRICEU 17 METRICSU?????? METRICEU 17 METRICSU? ??????? METRICEU 17 METRICSUre-schema ??????? METRICEU 17 METRICSU???? METRICEU 17 METRICSU? CREATE SEQUENCE "PAR_SYS_OPERATOR_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 58 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_SYS_SCHEDULEDTASK_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_SYS_SUBMENU_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 7102 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_SYS_SUBSYSTEM_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 3 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "TOAD_PLAN_TABLE_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 10 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_ACQ_CHECK_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_ACQ_COLLECTBIB_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_ACQ_ORDER_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_ACQ_RECOMMEND_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_BIBLIOGRAPHY_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_CAT_SUBJECT_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 154059 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_CIR_FINELOG_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_CIR_LOG_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_CIR_READER_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_CIR_RESERVE_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_COM_CONFIG_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 63 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_HOLDINGS_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_PER_CHECK_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_PER_DETAIL_CHECK_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_PER_ORDER_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_SYS_OPLOG_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_TITLE_NUMBER_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_ACQ_RATE_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 6 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_CAT_REPEAT_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 3 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_CAT_TEMPLATE_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 3 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_CAT_Z3950_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 5 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_CIR_CIRRULE_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 7 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_CIR_DELAY_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 22 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_CIR_READERFIELD_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 65 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_SYS_AUTHORITYGROUP_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 8 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_SYS_BARCODE_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_SYS_EMAIL_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "PAR_SYS_MENU_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 7101 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_HLDLOG_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_PER_BIND_SEQ" MINVALUE 1 MAXVALUE 10000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_SYSLOG_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "OPAC_BOOKCASE_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "OPAC_BOOKREVIEW_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "OPAC_RETRIEVE_BOOKLOG_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "OPAC_RETRIEVE_RDRLOG_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "OPAC_VISIT_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_PAGE_CONFIG_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE CREATE SEQUENCE "LIB_BOOKCLASS_SEQ" MINVALUE 1 MAXVALUE 1000000000000000000000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE METRICEU 60 METRICSU?? METRICEU 60 METRICSUXDB Schemas by user METRICEU 60 TABLE "LIB_ACQ_ALLOCATION" CREATE TABLE "LIB_ACQ_ALLOCATION" ("LIBCODE" VARCHAR2(10 CHAR), "LOCCODE" VARCHAR2(10 CHAR), "COPIES" NUMBER(6, 0) NOT NULL ENABLE, "ORDERID" NUMBER(10, 0) NOT NULL ENABLE, "DOCTYPE" VARCHAR2(10 CHAR)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "JISHEN" LOGGING NOCOMPRESS INSERT INTO "LIB_ACQ_ALLOCATION" ("LIBCODE", "LOCCODE", "COPIES", "ORDERID", "DOCTYPE") VALUES (:1, :2, :3, :4, :5) g g g ?? CREATE INDEX "LIB_ACQ_ALLOCATION_ORDERID" ON "LIB_ACQ_ALLOCATION" ("ORDERID" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "JISHEN" LOGGING ANALSTATS IR "LIB_ACQ_ALLOCATION" k BEGIN DBMS_STATS.SET_INDEX_STATS(NULL,'"LIB_ACQ_ALLOCATION_ORDERID"',NULL,NULL,NULL,0,0,0,0,0,0,0,0); END; TABLE "LIB_ACQ_BOOKSELLER" CREATE TABLE "LIB_ACQ_BOOKSELLER" ("CODE" VARCHAR2(32 CHAR) NOT NULL ENABLE, "LIBCODE" VARCHAR2(10 CHAR) NOT NULL ENABLE, "NAME" VARCHAR2(20 CHAR) NOT NULL ENABLE, "LINKMAN" VARCHAR2(20 CHAR), "ADDRESS" VARCHAR2(100 CHAR), "TEL1" VARCHAR2(32 CHAR), "TEL2" VARCHAR2(32 CHAR), "EMAIL" VARCHAR2(60 CHAR), "LEVEL" CHAR(1 CHAR), "ACCOUNT" VARCHAR2(30 CHAR), "BANK" VARCHAR2(30 CHAR), "NOTE" VARCHAR2(30 CHAR)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "JISHEN" LOGGING NOCOMPRESS INSERT INTO "LIB_ACQ_BOOKSELLER" ("CODE", "LIBCODE", "NAME", "LINKMAN", "ADDRESS", "TEL1", "TEL2", "EMAIL", "LEVEL", "ACCOUNT", "BANK", "NOTE") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) ` g g <