Oracle数据库快照创建与管理

----sheng----------------------------------------
CREATE MATERIALIZED VIEW LOG ON param_city WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_codes WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_datastate WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_kjconfig WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_kjinfo WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_logup WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_sensorcode WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_sensortype WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON param_stationstate WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_aircompressor WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_cadevice WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_ch WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_changedata WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_corporationinfo WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_detailsinfo WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_equipment WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_esupply WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_fan WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_file WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_firedustdefense WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_gzm WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_handle WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_handlehistory WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_material WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_measure WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_methanecut WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_methanesensor WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_minesituation WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_person WITH PRIMARY KEY INCLUDING NEW VALUES; 

CREATE MATERIALIZED VIEW LOG ON mkxx_safemonitor WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_secapparatus WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_selfassessment WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_uploadmap WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_upwinch WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_waterpump WITH PRIMARY KEY INCLUDING NEW VALUES; 
CREATE MATERIALIZED VIEW LOG ON mkxx_windduct WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_history WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_historydetail WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_material WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_materialconfig WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_person WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_resource WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_mgroup WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_mperson WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_mresource WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_mgp_r WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_yg_r WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_yr_r WITH PRIMARY KEY INCLUDING NEW VALUES;
CREATE MATERIALIZED VIEW LOG ON ya_info WITH PRIMARY KEY INCLUDING NEW VALUES;
--------------------------------------------------
--地市数据库
--conn FJMJ/FJMJ@LYMJ;

-- Drop existing database link 
--drop public database link FJMJ.ORCL.COM.CN;
-- Create database link 
--create public database link FJMJ.ORCL.COM.CN
--  connect to FJMJ
--  using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.1.11)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))';