山东环保数据库迁移

来源：互联网发布：js定义长度为4的数组编辑：程序博客网时间：2024/04/19 17:59

1、导出数据

SQL> set pagesize 1200;

SQL> set linesize 150;

SQL> col directory_path format a80

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH

------------------------------ ------------------------------ --------------------------------------------------------------------------------

SYS SUBDIR /home/app/oracle/product/11.2.0/dbhome_1/demo/schema/order_entry//2002/Sep

SYS SS_OE_XMLDIR /home/app/oracle/product/11.2.0/dbhome_1/demo/schema/order_entry/

SYS DUMP_FILE_DIR /home/oracle/backup/dmp

SYS LOG_FILE_DIR /home/app/oracle/product/11.2.0/dbhome_1/demo/schema/log/

SYS MEDIA_DIR /home/app/oracle/product/11.2.0/dbhome_1/demo/schema/product_media/

SYS DATA_FILE_DIR /home/app/oracle/product/11.2.0/dbhome_1/demo/schema/sales_history/

SYS XMLDIR /home/app/oracle/product/11.2.0/dbhome_1/rdbms/xml

SYS ORACLE_OCM_CONFIG_DIR /home/app/oracle/product/11.2.0/dbhome_1/ccr/hosts/yjyb-db/state

SYS DATA_PUMP_DIR /home/app/admin/orcl/dpdump/

SYS ORACLE_OCM_CONFIG_DIR2 /home/app/oracle/product/11.2.0/dbhome_1/ccr/state

[oracle@yjyb-db dmp]$ pwd

/home/oracle/backup/dmp

[oracle@yjyb-db dmp]$ expdp cshb/CSHB123 directory=DUMP_FILE_DIR dumpfile=cshb_%U.dmp nologfile=y parallel=6

Export: Release 11.2.0.4.0 - Production on Thu May 26 18:48:10 2016

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "CSHB"."SYS_EXPORT_SCHEMA_01": cshb/******** directory=DUMP_FILE_DIR dumpfile=cshb_%U.dmp nologfile=y parallel=6

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 17.47 GB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

. . exported "CSHB"."T_G237_ENVI_YJ_WEATHER" 14.10 KB 5 rows

. . exported "CSHB"."T_G237_FORCASE_WEATHE_DATA" 4.443 MB 50864 rows

. . exported "CSHB"."T_G237_FORCASE_WEATHE_DATA_DAY" 10.40 KB 17 rows

. . exported "CSHB"."T_G237_FORCASE_RT_STATE_TEMP" 30.20 MB 282188 rows

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

. . exported "CSHB"."T_G237_FORCASE_RT_STATE_NL" 486.0 MB 3049400 rows

Processing object type SCHEMA_EXPORT/TABLE/TABLE

. . exported "CSHB"."T_G237_MONITOR_RT" 791.5 MB 14500825 rows

. . exported "CSHB"."T_G237_REPORT_RT_SQL" 450.6 MB 4376892 rows

. . exported "CSHB"."QRTZ_JOB_LOG" 246.8 MB 2037323 rows

. . exported "CSHB"."TB_NRT_SN_QX_RT_STATION_H" 8.857 MB 125313 rows

. . exported "CSHB"."T_G237_MONITOR_RT_COUNTRY" 427.0 MB 4728975 rows

. . exported "CSHB"."TB_NRT_SN_QX_AUD_STATION_H" 12.82 MB 179451 rows

. . exported "CSHB"."T_G237_REPORT_RT_CITY_STATE" 117.3 MB 775904 rows

. . exported "CSHB"."T_G237_MONITOR_RT_STATE" 130.8 MB 979605 rows

. . exported "CSHB"."TB_NRT_SN_QX_RT_CITY_D" 99.80 KB 1308 rows

. . exported "CSHB"."TB_NRT_SN_QX_RT_CITY_H" 1.642 MB 29712 rows

. . exported "CSHB"."TB_NRT_SN_QX_RT_CITY_M" 12.89 KB 34 rows

. . exported "CSHB"."TB_NRT_SN_QX_RT_STATION_D" 430.7 KB 5559 rows

. . exported "CSHB"."TB_NRT_SN_QX_RT_STATION_M" 23.82 KB 174 rows

. . exported "CSHB"."T_G237_FORCASE_RT_STATE" 113.2 MB 899551 rows

. . exported "CSHB"."T_G237_MONITOR_RT_CITY_STATE" 41.03 MB 271962 rows

. . exported "CSHB"."T_G237_WEATHE_RT_DATA_DAY" 21.99 KB 123 rows

. . exported "CSHB"."T_G237_WEATHE_RT_DATA_MONTH" 22.20 KB 123 rows

. . exported "CSHB"."T_G237_WEATHE_RT_DATA_YEAR" 22.41 KB 123 rows

. . exported "CSHB"."T_G237_REPORT_RT_TEMP" 1.806 GB 31375676 rows

. . exported "CSHB"."T_G237_REPORT_RT_TEMP_HIS" 1.824 GB 38292003 rows

. . exported "CSHB"."T_G237_WEATHE_RT_DATA" 3.891 MB 46430 rows

. . exported "CSHB"."T_G237_MONITOR_RT_TEMP_HIS" 1.828 GB 38370977 rows

. . exported "CSHB"."T_G237_FORECAST_TJ_RES" 13.07 MB 76258 rows

. . exported "CSHB"."T_G237_REPORT_RT_HIS_TEMP" 12.66 MB 265000 rows

. . exported "CSHB"."CN0220122014" 12.29 MB 280759 rows

. . exported "CSHB"."T_G237_REPORT_CITY_TEMP" 8.992 MB 149281 rows

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

. . exported "CSHB"."T_G237_MONITOR_TR_H" 54.33 MB 257513 rows

. . exported "CSHB"."T_G237_QC_RT" 10.72 MB 85757 rows

. . exported "CSHB"."T_G237_REPROT_STATION_DAY_AQI" 7.417 MB 87588 rows

. . exported "CSHB"."T_G237_FORECAST_TJ_TEMP" 1.342 MB 8424 rows

. . exported "CSHB"."T_G237_MONITOR_COUNT_RT" 5.970 MB 93707 rows

. . exported "CSHB"."T_G237_DC_TSI_RT" 7.926 MB 15761 rows

. . exported "CSHB"."T_G237_PRODUCT_AREA" 5.368 MB 1170 rows

. . exported "CSHB"."TB_NRT_SN_QX_AUD_CITY_H" 4.373 MB 75620 rows

. . exported "CSHB"."T_G237_MONITOR_RT1" 4.395 MB 68903 rows

. . exported "CSHB"."TEMP" 7.071 MB 46241 rows

. . exported "CSHB"."T_G237_FORCASE_STATE_TEMP_D1" 2.588 MB 27176 rows

. . exported "CSHB"."T_G237_REPROT_CTIY_DAILY" 3.146 MB 33015 rows

. . exported "CSHB"."CN0120122013" 2.322 MB 53177 rows

. . exported "CSHB"."T_G237_FORCASE_RT_DAILY" 2.085 MB 21182 rows

. . exported "CSHB"."T_G237_PRODUCT_CITY_FORECAST" 475.5 KB 5002 rows

. . exported "CSHB"."T_G237_INFO_LOGIN_LOG" 874.8 KB 15529 rows

. . exported "CSHB"."T_G237_MONITOR_CTIY_DAILY" 1.082 MB 10941 rows

. . exported "CSHB"."ENVI_YJ_AREA" 2.566 MB 62 rows

. . exported "CSHB"."QRTZ_JOB_SCHED_ATUO" 2.983 MB 42922 rows

. . exported "CSHB"."T_G237_PRODUCT_CITY_PUBLISH" 23.35 KB 132 rows

. . exported "CSHB"."T_G237_REPROT_CTIY_DAY_AQI" 15.47 KB 8 rows

. . exported "CSHB"."T_G237_REPROT_STATION_DAY" 347.1 KB 3359 rows

. . exported "CSHB"."T_G237_SYS_LOG" 806.0 KB 34128 rows

. . exported "CSHB"."T_G237_MONITOR_QC_RT" 1.252 MB 9532 rows

. . exported "CSHB"."TB_NRT_SN_QX_AUD_STATION_D" 654.1 KB 8632 rows

. . exported "CSHB"."EMAIL_TEST_FORCASE_WEATHE_DATA" 375.5 KB 4080 rows

. . exported "CSHB"."T_G237_MONITOR_STATION_DAY_AQI" 1.428 MB 17032 rows

. . exported "CSHB"."NILEI_TEST" 75.56 MB 580802 rows

. . exported "CSHB"."T_G237_PRODUCT_CITY_LOG" 557.4 KB 5865 rows

. . exported "CSHB"."T_G237_INFO_MENU" 35.86 KB 263 rows

. . exported "CSHB"."T_G237_DC_HG_RT" 546.7 KB 6394 rows

. . exported "CSHB"."T_G237_INFO_MONITOR_STATION" 41.57 KB 358 rows

. . exported "CSHB"."T_G237_INFO_NMC_CITY" 9.125 KB 15 rows

. . exported "CSHB"."T_G237_INFO_QC_STATION" 12.25 KB 45 rows

. . exported "CSHB"."T_G237_INFO_ROLE" 5.992 KB 4 rows

. . exported "CSHB"."T_G237_INFO_ROLE_AND_MENU" 15.14 KB 534 rows

. . exported "CSHB"."T_G237_DC_ACSM_RT" 462.9 KB 9377 rows

. . exported "CSHB"."T_G237_INFO_ROLE_AND_USER" 5.695 KB 21 rows

. . exported "CSHB"."T_G237_PRODUCT_AREA_CITY" 407.5 KB 5151 rows

. . exported "CSHB"."T_G237_INFO_STATION_QUOTA" 11.39 KB 38 rows

. . exported "CSHB"."T_G237_PRODUCT_CITY_COMPARE_P" 34.97 KB 204 rows

. . exported "CSHB"."T_G237_INFO_USER" 13.01 KB 20 rows

. . exported "CSHB"."T_G237_REPROT_STATION_DAILY" 416.8 KB 3513 rows

. . exported "CSHB"."T_G237_INFO_WEATHE_STATION" 13.44 KB 70 rows

. . exported "CSHB"."T_G237_INFO_YQD" 15.22 KB 34 rows

. . exported "CSHB"."T_G237_MONITOR_POLLUTANT_AMBIT" 8.562 KB 9 rows

. . exported "CSHB"."T_G237_SCHED_JOB" 329.3 KB 1703 rows

. . exported "CSHB"."T_G237_MONITOR_STATION_TYPE" 10.03 KB 429 rows

. . exported "CSHB"."T_G237_DC_HG_RT_STATE" 288.0 KB 5673 rows

. . exported "CSHB"."T_G237_MONITOR_WARN" 31.47 KB 217 rows

. . exported "CSHB"."TB_NRT_SN_QX_AUD_CITY_D" 232.6 KB 3334 rows

. . exported "CSHB"."T_G237_MONITOR_WEATHER_H" 8.882 KB 5 rows

. . exported "CSHB"."T_G237_FLOW_FORECAST_DATA" 160.9 KB 220 rows

. . exported "CSHB"."T_G237_PRODUCT_INFO_INTERVAL" 31.24 KB 157 rows

. . exported "CSHB"."T_G237_MONTH_HISTORY" 237.6 KB 2957 rows

. . exported "CSHB"."T_G237_QV_CATEGORY" 11.25 KB 31 rows

. . exported "CSHB"."T_G237_PRODUCT_INFO_LOG" 220.4 KB 1282 rows

. . exported "CSHB"."T_G237_REPORT_POLLUTANT_AMBIT" 8.289 KB 10 rows

. . exported "CSHB"."T_G237_DC_MARGA_RT" 156.7 KB 1758 rows

. . exported "CSHB"."T_G237_FAVORITEFILE_MODEL" 23.12 KB 31 rows

. . exported "CSHB"."T_SPS_DALIY_TASK_TO_PRESON" 9.914 KB 3 rows

. . exported "CSHB"."T_G237_FORC_NEURNET_RT_DAY" 160.2 KB 1530 rows

. . exported "CSHB"."T_TEMP" 14.28 KB 11 rows

. . exported "CSHB"."QRTZ_BLOB_TRIGGERS" 0 KB 0 rows

. . exported "CSHB"."QRTZ_CALENDARS" 0 KB 0 rows

. . exported "CSHB"."QRTZ_PAUSED_TRIGGER_GRPS" 0 KB 0 rows

. . exported "CSHB"."QRTZ_SCHEDULER_STATE" 0 KB 0 rows

. . exported "CSHB"."QRTZ_SIMPLE_TRIGGERS" 0 KB 0 rows

. . exported "CSHB"."QRTZ_SIMPROP_TRIGGERS" 0 KB 0 rows

. . exported "CSHB"."T_G237_FORECAST_VISIBILITY" 196.0 KB 5035 rows

. . exported "CSHB"."T_AIR_SN_SUP_ORI_INSTRUMENT" 0 KB 0 rows

. . exported "CSHB"."T_AIR_SN_SUP_ORI_MONITORITEM" 0 KB 0 rows

. . exported "CSHB"."T_AIR_SN_SUP_ORI_RAWDATA" 0 KB 0 rows

. . exported "CSHB"."T_G237_DC_VOC_RT" 0 KB 0 rows

. . exported "CSHB"."T_G237_FAVORITEFILE_USER" 0 KB 0 rows

. . exported "CSHB"."T_G237_FAVORITE_BUS_USER" 0 KB 0 rows

. . exported "CSHB"."T_G237_FAVORITE_USER" 0 KB 0 rows

. . exported "CSHB"."T_G237_FLOW_FORECAST_LOG" 0 KB 0 rows

. . exported "CSHB"."T_G237_FLOW_FORECAST_MODEL" 0 KB 0 rows

. . exported "CSHB"."T_G237_INFO_USER_AND_MENU" 0 KB 0 rows

. . exported "CSHB"."T_G237_PRODUCT_AREA_COMPARE" 0 KB 0 rows

. . exported "CSHB"."T_G237_PRODUCT_CITY_COMPARE" 0 KB 0 rows

. . exported "CSHB"."T_G237_REPORT_RT" 0 KB 0 rows

. . exported "CSHB"."T_G237_INFO_COUNTRY_STATION" 162.3 KB 1434 rows

. . exported "CSHB"."T_G237_QV_PRODUCT" 162.0 KB 477 rows

. . exported "CSHB"."T_G237_DOC_PRODUCT" 86.82 KB 24 rows

. . exported "CSHB"."T_G237_FORCASE_WEATHE_HAND" 112.4 KB 1496 rows

. . exported "CSHB"."QRTZ_JOB_DETAILS" 12.98 KB 24 rows

. . exported "CSHB"."QRTZ_JOB_NCL_CMMAND" 63.31 KB 242 rows

. . exported "CSHB"."QRTZ_TRIGGERS" 14.03 KB 24 rows

. . exported "CSHB"."T_G237_DC_JNO_RT" 68.44 KB 1948 rows

. . exported "CSHB"."T_G237_DC_PAN_RT" 62.85 KB 966 rows

. . exported "CSHB"."T_G237_FAVORITE_BUS_MODEL" 13.18 KB 44 rows

. . exported "CSHB"."T_G237_FLOW_FORECAST_MAKE" 18.03 KB 74 rows

. . exported "CSHB"."T_G237_MONITOR_QC_AUDIT_RT" 90.29 KB 1102 rows

. . exported "CSHB"."T_G237_MONITOR_STATION_DAILY" 70.53 KB 622 rows

. . exported "CSHB"."T_G237_PRODUCT_AREA_COMPARE_P" 17.77 KB 17 rows

. . exported "CSHB"."T_G237_PRODUCT_INFO" 68.35 KB 249 rows

. . exported "CSHB"."T_G237_PRODUCT_INFO_PUBLISH" 9.187 KB 12 rows

. . exported "CSHB"."ENVI_CITY" 7.695 KB 18 rows

. . exported "CSHB"."ENVI_COUNTY" 11.06 KB 97 rows

. . exported "CSHB"."ENVI_COUNTY_STATION_INFO" 39.31 KB 189 rows

. . exported "CSHB"."ENVI_STATION_CODE" 10.64 KB 79 rows

. . exported "CSHB"."ENVI_STATION_INFO" 47.26 KB 173 rows

. . exported "CSHB"."QRTZ_CRON_TRIGGERS" 8.179 KB 24 rows

. . exported "CSHB"."QRTZ_FIRED_TRIGGERS" 10.13 KB 1 rows

. . exported "CSHB"."QRTZ_JOB_NCL" 9.437 KB 31 rows

. . exported "CSHB"."QRTZ_JOB_PROPERTIES" 21.40 KB 35 rows

. . exported "CSHB"."QRTZ_LOCKS" 5.453 KB 1 rows

. . exported "CSHB"."TB_NRT_SN_QX_AUD_CITY_M" 16.17 KB 85 rows

. . exported "CSHB"."TB_NRT_SN_QX_AUD_STATION_M" 29.67 KB 256 rows

. . exported "CSHB"."T_G237_CATEGORY_QUOTA_RELATION" 5.585 KB 6 rows

. . exported "CSHB"."T_G237_CITY_CATEGORY" 5.890 KB 1 rows

. . exported "CSHB"."T_G237_CITY_CATEGORY_RELATION" 6.570 KB 13 rows

. . exported "CSHB"."T_G237_CITY_STATTION_RELATION" 8.671 KB 72 rows

. . exported "CSHB"."T_G237_DC_LV_RT" 12.34 KB 174 rows

. . exported "CSHB"."T_G237_DC_VOC_CATE" 18.06 KB 99 rows

. . exported "CSHB"."T_G237_FAVORITE_MODEL" 8.421 KB 2 rows

. . exported "CSHB"."T_G237_FLOW_FORECAST_BUS" 10.92 KB 28 rows

. . exported "CSHB"."T_G237_FLOW_FORECAST_EXAMPLE" 8.960 KB 14 rows

. . exported "CSHB"."T_G237_FORECAST_TJ_SCORE" 40.30 KB 494 rows

. . exported "CSHB"."T_G237_GRID_STATION_D1" 14.76 KB 158 rows

. . exported "CSHB"."T_G237_GRID_STATION_D2" 14.70 KB 158 rows

. . exported "CSHB"."T_G237_GRID_STATION_RELATION" 14.72 KB 158 rows

. . exported "CSHB"."T_G237_INFO_AREA" 14.53 KB 115 rows

. . exported "CSHB"."T_G237_INFO_COLLECT_COUNT" 8.039 KB 36 rows

. . exported "CSHB"."T_G237_INFO_LOGIN_ERROR" 7.179 KB 15 rows

Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION

. . exported "CSHB"."T_G237_PRODUCT_AREA_PUBLISH" 6.330 MB 38 rows

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

. . exported "CSHB"."T_G237_PRODUCT_AREA_INTERVAL" 38.89 MB 2564 rows

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Master table "CSHB"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded

******************************************************************************

Dump file set for CSHB.SYS_EXPORT_SCHEMA_01 is:

/home/oracle/backup/dmp/cshb_01.dmp

/home/oracle/backup/dmp/cshb_02.dmp

/home/oracle/backup/dmp/cshb_03.dmp

/home/oracle/backup/dmp/cshb_04.dmp

/home/oracle/backup/dmp/cshb_05.dmp

/home/oracle/backup/dmp/cshb_06.dmp

Job "CSHB"."SYS_EXPORT_SCHEMA_01" successfully completed at Thu May 26 18:49:01 2016 elapsed 0 00:00:49

[oracle@yjyb-db dmp]$

2、将数据复制到83库上面

SQL> set pagesize 1200;

SQL> set linesize 150;

SQL> col directory_path format a80

SQL> select * from dba_directories;

OWNER DIRECTORY_NAME DIRECTORY_PATH

------------------------------ ------------------------------ --------------------------------------------------------------------------------

SYS DUMP_FILE_DIR /home/backup/dmp

SYS XMLDIR /home/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/xml

SYS ORACLE_OCM_CONFIG_DIR /home/u01/app/oracle/product/11.2.0/dbhome_1/ccr/hosts/yjyb-db1/state

SYS DATA_PUMP_DIR /home/u01/app/admin/orcl/dpdump/

SYS ORACLE_OCM_CONFIG_DIR2 /home/u01/app/oracle/product/11.2.0/dbhome_1/ccr/state

[oracle@yjyb-db dmp]$ scp cshb_* oracle@10.37.18.83:/home/backup/dmp

oracle@10.37.18.83's password:

cshb_01.dmp 100% 1360KB 1.3MB/s 00:00

cshb_02.dmp 100% 1583MB 105.5MB/s 00:15

cshb_03.dmp 100% 1936MB 113.9MB/s 00:17

cshb_04.dmp 100% 1432MB 110.2MB/s 00:13

cshb_05.dmp 100% 1929MB 113.5MB/s 00:17

cshb_06.dmp 100% 1888MB 111.1MB/s 00:17

3、将dmp文件导入新用户当中

[oracle@yjyb-db1 dmp]$ impdp yjyb/yjyb directory=DUMP_FILE_DIR dumpfile=cshb_01.dmp,cshb_02.dmp,cshb_03.dmp,cshb_04.dmp,cshb_05.dmp,cshb_06.dmp nologfile=y remap_schema=cshb:yjyb table_exists_action=replace

Import: Release 11.2.0.4.0 - Production on Thu May 26 19:01:38 2016

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Master table "YJYB"."SYS_IMPORT_FULL_01" successfully loaded/unloaded

Starting "YJYB"."SYS_IMPORT_FULL_01": yjyb/******** directory=DUMP_FILE_DIR dumpfile=cshb_01.dmp,cshb_02.dmp,cshb_03.dmp,cshb_04.dmp,cshb_05.dmp,cshb_06.dmp nologfile=y remap_schema=cshb:yjyb table_exists_action=replace

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"YJYB" already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

. . imported "YJYB"."T_G237_REPORT_RT_TEMP" 1.806 GB 31375676 rows

. . imported "YJYB"."T_G237_MONITOR_RT_TEMP_HIS" 1.828 GB 38370977 rows

. . imported "YJYB"."T_G237_REPORT_RT_TEMP_HIS" 1.824 GB 38292003 rows

. . imported "YJYB"."T_G237_FORCASE_WEATHE_DATA" 4.443 MB 50864 rows

. . imported "YJYB"."T_G237_ENVI_YJ_WEATHER" 14.10 KB 5 rows

. . imported "YJYB"."T_G237_FORCASE_WEATHE_DATA_DAY" 10.40 KB 17 rows

. . imported "YJYB"."T_G237_MONITOR_RT" 791.5 MB 14500825 rows

. . imported "YJYB"."T_G237_FORCASE_RT_STATE_TEMP" 30.20 MB 282188 rows

. . imported "YJYB"."T_G237_FORCASE_RT_STATE_NL" 486.0 MB 3049400 rows

. . imported "YJYB"."T_G237_REPORT_RT_SQL" 450.6 MB 4376892 rows

. . imported "YJYB"."T_G237_MONITOR_RT_COUNTRY" 427.0 MB 4728975 rows

. . imported "YJYB"."QRTZ_JOB_LOG" 246.8 MB 2037323 rows

. . imported "YJYB"."TB_NRT_SN_QX_RT_STATION_H" 8.857 MB 125313 rows

. . imported "YJYB"."TB_NRT_SN_QX_AUD_STATION_H" 12.82 MB 179451 rows

. . imported "YJYB"."T_G237_MONITOR_RT_STATE" 130.8 MB 979605 rows

. . imported "YJYB"."T_G237_REPORT_RT_CITY_STATE" 117.3 MB 775904 rows

. . imported "YJYB"."T_G237_FORCASE_RT_STATE" 113.2 MB 899551 rows

. . imported "YJYB"."TB_NRT_SN_QX_RT_CITY_D" 99.80 KB 1308 rows

. . imported "YJYB"."TB_NRT_SN_QX_RT_CITY_H" 1.642 MB 29712 rows

. . imported "YJYB"."TB_NRT_SN_QX_RT_CITY_M" 12.89 KB 34 rows

. . imported "YJYB"."TB_NRT_SN_QX_RT_STATION_D" 430.7 KB 5559 rows

. . imported "YJYB"."TB_NRT_SN_QX_RT_STATION_M" 23.82 KB 174 rows

. . imported "YJYB"."NILEI_TEST" 75.56 MB 580802 rows

. . imported "YJYB"."T_G237_MONITOR_RT_CITY_STATE" 41.03 MB 271962 rows

. . imported "YJYB"."T_G237_WEATHE_RT_DATA_DAY" 21.99 KB 123 rows

. . imported "YJYB"."T_G237_WEATHE_RT_DATA_MONTH" 22.20 KB 123 rows

. . imported "YJYB"."T_G237_WEATHE_RT_DATA_YEAR" 22.41 KB 123 rows

. . imported "YJYB"."T_G237_MONITOR_TR_H" 54.33 MB 257513 rows

. . imported "YJYB"."T_G237_PRODUCT_AREA_INTERVAL" 38.89 MB 2564 rows

. . imported "YJYB"."T_G237_WEATHE_RT_DATA" 3.891 MB 46430 rows

. . imported "YJYB"."T_G237_FORECAST_TJ_RES" 13.07 MB 76258 rows

. . imported "YJYB"."CN0220122014" 12.29 MB 280759 rows

. . imported "YJYB"."T_G237_REPORT_RT_HIS_TEMP" 12.66 MB 265000 rows

. . imported "YJYB"."T_G237_QC_RT" 10.72 MB 85757 rows

. . imported "YJYB"."T_G237_REPORT_CITY_TEMP" 8.992 MB 149281 rows

. . imported "YJYB"."T_G237_DC_TSI_RT" 7.926 MB 15761 rows

. . imported "YJYB"."T_G237_REPROT_STATION_DAY_AQI" 7.417 MB 87588 rows

. . imported "YJYB"."TEMP" 7.071 MB 46241 rows

. . imported "YJYB"."T_G237_FORECAST_TJ_TEMP" 1.342 MB 8424 rows

. . imported "YJYB"."T_G237_MONITOR_COUNT_RT" 5.970 MB 93707 rows

. . imported "YJYB"."T_G237_PRODUCT_AREA_PUBLISH" 6.330 MB 38 rows

. . imported "YJYB"."T_G237_PRODUCT_AREA" 5.368 MB 1170 rows

. . imported "YJYB"."TB_NRT_SN_QX_AUD_CITY_H" 4.373 MB 75620 rows

. . imported "YJYB"."T_G237_MONITOR_RT1" 4.395 MB 68903 rows

. . imported "YJYB"."ENVI_YJ_AREA" 2.566 MB 62 rows

. . imported "YJYB"."QRTZ_JOB_SCHED_ATUO" 2.983 MB 42922 rows

. . imported "YJYB"."T_G237_FORCASE_STATE_TEMP_D1" 2.588 MB 27176 rows

. . imported "YJYB"."T_G237_REPROT_CTIY_DAILY" 3.146 MB 33015 rows

. . imported "YJYB"."CN0120122013" 2.322 MB 53177 rows

. . imported "YJYB"."T_G237_FORCASE_RT_DAILY" 2.085 MB 21182 rows

. . imported "YJYB"."T_G237_PRODUCT_CITY_FORECAST" 475.5 KB 5002 rows

. . imported "YJYB"."T_G237_INFO_LOGIN_LOG" 874.8 KB 15529 rows

. . imported "YJYB"."T_G237_MONITOR_CTIY_DAILY" 1.082 MB 10941 rows

. . imported "YJYB"."T_G237_MONITOR_QC_RT" 1.252 MB 9532 rows

. . imported "YJYB"."T_G237_MONITOR_STATION_DAY_AQI" 1.428 MB 17032 rows

. . imported "YJYB"."T_G237_PRODUCT_CITY_LOG" 557.4 KB 5865 rows

. . imported "YJYB"."T_G237_PRODUCT_CITY_PUBLISH" 23.35 KB 132 rows

. . imported "YJYB"."T_G237_REPROT_CTIY_DAY_AQI" 15.47 KB 8 rows

. . imported "YJYB"."T_G237_REPROT_STATION_DAY" 347.1 KB 3359 rows

. . imported "YJYB"."T_G237_SYS_LOG" 806.0 KB 34128 rows

. . imported "YJYB"."TB_NRT_SN_QX_AUD_STATION_D" 654.1 KB 8632 rows

. . imported "YJYB"."EMAIL_TEST_FORCASE_WEATHE_DATA" 375.5 KB 4080 rows

. . imported "YJYB"."T_G237_DC_HG_RT" 546.7 KB 6394 rows

. . imported "YJYB"."T_G237_DC_ACSM_RT" 462.9 KB 9377 rows

. . imported "YJYB"."T_G237_PRODUCT_AREA_CITY" 407.5 KB 5151 rows

. . imported "YJYB"."T_G237_PRODUCT_CITY_COMPARE_P" 34.97 KB 204 rows

. . imported "YJYB"."T_G237_REPROT_STATION_DAILY" 416.8 KB 3513 rows

. . imported "YJYB"."T_G237_SCHED_JOB" 329.3 KB 1703 rows

. . imported "YJYB"."T_G237_DC_HG_RT_STATE" 288.0 KB 5673 rows

. . imported "YJYB"."TB_NRT_SN_QX_AUD_CITY_D" 232.6 KB 3334 rows

. . imported "YJYB"."T_G237_FLOW_FORECAST_DATA" 160.9 KB 220 rows

. . imported "YJYB"."T_G237_MONTH_HISTORY" 237.6 KB 2957 rows

. . imported "YJYB"."T_G237_PRODUCT_INFO_LOG" 220.4 KB 1282 rows

. . imported "YJYB"."T_G237_DC_MARGA_RT" 156.7 KB 1758 rows

. . imported "YJYB"."T_G237_FAVORITEFILE_MODEL" 23.12 KB 31 rows

. . imported "YJYB"."T_G237_FORC_NEURNET_RT_DAY" 160.2 KB 1530 rows

. . imported "YJYB"."T_G237_FORECAST_VISIBILITY" 196.0 KB 5035 rows

. . imported "YJYB"."T_G237_INFO_COUNTRY_STATION" 162.3 KB 1434 rows

. . imported "YJYB"."T_G237_QV_PRODUCT" 162.0 KB 477 rows

. . imported "YJYB"."T_G237_DOC_PRODUCT" 86.82 KB 24 rows

. . imported "YJYB"."T_G237_FORCASE_WEATHE_HAND" 112.4 KB 1496 rows

. . imported "YJYB"."QRTZ_JOB_DETAILS" 12.98 KB 24 rows

. . imported "YJYB"."QRTZ_JOB_NCL_CMMAND" 63.31 KB 242 rows

. . imported "YJYB"."QRTZ_TRIGGERS" 14.03 KB 24 rows

. . imported "YJYB"."T_G237_DC_JNO_RT" 68.44 KB 1948 rows

. . imported "YJYB"."T_G237_DC_PAN_RT" 62.85 KB 966 rows

. . imported "YJYB"."T_G237_FAVORITE_BUS_MODEL" 13.18 KB 44 rows

. . imported "YJYB"."T_G237_FLOW_FORECAST_MAKE" 18.03 KB 74 rows

. . imported "YJYB"."T_G237_MONITOR_QC_AUDIT_RT" 90.29 KB 1102 rows

. . imported "YJYB"."T_G237_MONITOR_STATION_DAILY" 70.53 KB 622 rows

. . imported "YJYB"."T_G237_PRODUCT_AREA_COMPARE_P" 17.77 KB 17 rows

. . imported "YJYB"."T_G237_PRODUCT_INFO" 68.35 KB 249 rows

. . imported "YJYB"."T_G237_PRODUCT_INFO_PUBLISH" 9.187 KB 12 rows

. . imported "YJYB"."ENVI_CITY" 7.695 KB 18 rows

. . imported "YJYB"."ENVI_COUNTY" 11.06 KB 97 rows

. . imported "YJYB"."ENVI_COUNTY_STATION_INFO" 39.31 KB 189 rows

. . imported "YJYB"."ENVI_STATION_CODE" 10.64 KB 79 rows

. . imported "YJYB"."ENVI_STATION_INFO" 47.26 KB 173 rows

. . imported "YJYB"."QRTZ_CRON_TRIGGERS" 8.179 KB 24 rows

. . imported "YJYB"."QRTZ_FIRED_TRIGGERS" 10.13 KB 1 rows

. . imported "YJYB"."QRTZ_JOB_NCL" 9.437 KB 31 rows

. . imported "YJYB"."QRTZ_JOB_PROPERTIES" 21.40 KB 35 rows

. . imported "YJYB"."QRTZ_LOCKS" 5.453 KB 1 rows

. . imported "YJYB"."TB_NRT_SN_QX_AUD_CITY_M" 16.17 KB 85 rows

. . imported "YJYB"."TB_NRT_SN_QX_AUD_STATION_M" 29.67 KB 256 rows

. . imported "YJYB"."T_G237_CATEGORY_QUOTA_RELATION" 5.585 KB 6 rows

. . imported "YJYB"."T_G237_CITY_CATEGORY" 5.890 KB 1 rows

. . imported "YJYB"."T_G237_CITY_CATEGORY_RELATION" 6.570 KB 13 rows

. . imported "YJYB"."T_G237_CITY_STATTION_RELATION" 8.671 KB 72 rows

. . imported "YJYB"."T_G237_DC_LV_RT" 12.34 KB 174 rows

. . imported "YJYB"."T_G237_DC_VOC_CATE" 18.06 KB 99 rows

. . imported "YJYB"."T_G237_FAVORITE_MODEL" 8.421 KB 2 rows

. . imported "YJYB"."T_G237_FLOW_FORECAST_BUS" 10.92 KB 28 rows

. . imported "YJYB"."T_G237_FLOW_FORECAST_EXAMPLE" 8.960 KB 14 rows

. . imported "YJYB"."T_G237_FORECAST_TJ_SCORE" 40.30 KB 494 rows

. . imported "YJYB"."T_G237_GRID_STATION_D1" 14.76 KB 158 rows

. . imported "YJYB"."T_G237_GRID_STATION_D2" 14.70 KB 158 rows

. . imported "YJYB"."T_G237_GRID_STATION_RELATION" 14.72 KB 158 rows

. . imported "YJYB"."T_G237_INFO_AREA" 14.53 KB 115 rows

. . imported "YJYB"."T_G237_INFO_COLLECT_COUNT" 8.039 KB 36 rows

. . imported "YJYB"."T_G237_INFO_LOGIN_ERROR" 7.179 KB 15 rows

. . imported "YJYB"."T_G237_INFO_MENU" 35.86 KB 263 rows

. . imported "YJYB"."T_G237_INFO_MONITOR_STATION" 41.57 KB 358 rows

. . imported "YJYB"."T_G237_INFO_NMC_CITY" 9.125 KB 15 rows

. . imported "YJYB"."T_G237_INFO_QC_STATION" 12.25 KB 45 rows

. . imported "YJYB"."T_G237_INFO_ROLE" 5.992 KB 4 rows

. . imported "YJYB"."T_G237_INFO_ROLE_AND_MENU" 15.14 KB 534 rows

. . imported "YJYB"."T_G237_INFO_ROLE_AND_USER" 5.695 KB 21 rows

. . imported "YJYB"."T_G237_INFO_STATION_QUOTA" 11.39 KB 38 rows

. . imported "YJYB"."T_G237_INFO_USER" 13.01 KB 20 rows

. . imported "YJYB"."T_G237_INFO_WEATHE_STATION" 13.44 KB 70 rows

. . imported "YJYB"."T_G237_INFO_YQD" 15.22 KB 34 rows

. . imported "YJYB"."T_G237_MONITOR_POLLUTANT_AMBIT" 8.562 KB 9 rows

. . imported "YJYB"."T_G237_MONITOR_STATION_TYPE" 10.03 KB 429 rows

. . imported "YJYB"."T_G237_MONITOR_WARN" 31.47 KB 217 rows

. . imported "YJYB"."T_G237_MONITOR_WEATHER_H" 8.882 KB 5 rows

. . imported "YJYB"."T_G237_PRODUCT_INFO_INTERVAL" 31.24 KB 157 rows

. . imported "YJYB"."T_G237_QV_CATEGORY" 11.25 KB 31 rows

. . imported "YJYB"."T_G237_REPORT_POLLUTANT_AMBIT" 8.289 KB 10 rows

. . imported "YJYB"."T_SPS_DALIY_TASK_TO_PRESON" 9.914 KB 3 rows

. . imported "YJYB"."T_TEMP" 14.28 KB 11 rows

. . imported "YJYB"."QRTZ_BLOB_TRIGGERS" 0 KB 0 rows

. . imported "YJYB"."QRTZ_CALENDARS" 0 KB 0 rows

. . imported "YJYB"."QRTZ_PAUSED_TRIGGER_GRPS" 0 KB 0 rows

. . imported "YJYB"."QRTZ_SCHEDULER_STATE" 0 KB 0 rows

. . imported "YJYB"."QRTZ_SIMPLE_TRIGGERS" 0 KB 0 rows

. . imported "YJYB"."QRTZ_SIMPROP_TRIGGERS" 0 KB 0 rows

. . imported "YJYB"."T_AIR_SN_SUP_ORI_INSTRUMENT" 0 KB 0 rows

. . imported "YJYB"."T_AIR_SN_SUP_ORI_MONITORITEM" 0 KB 0 rows

. . imported "YJYB"."T_AIR_SN_SUP_ORI_RAWDATA" 0 KB 0 rows

. . imported "YJYB"."T_G237_DC_VOC_RT" 0 KB 0 rows

. . imported "YJYB"."T_G237_FAVORITEFILE_USER" 0 KB 0 rows

. . imported "YJYB"."T_G237_FAVORITE_BUS_USER" 0 KB 0 rows

. . imported "YJYB"."T_G237_FAVORITE_USER" 0 KB 0 rows

. . imported "YJYB"."T_G237_FLOW_FORECAST_LOG" 0 KB 0 rows

. . imported "YJYB"."T_G237_FLOW_FORECAST_MODEL" 0 KB 0 rows

. . imported "YJYB"."T_G237_INFO_USER_AND_MENU" 0 KB 0 rows

. . imported "YJYB"."T_G237_PRODUCT_AREA_COMPARE" 0 KB 0 rows

. . imported "YJYB"."T_G237_PRODUCT_CITY_COMPARE" 0 KB 0 rows

. . imported "YJYB"."T_G237_REPORT_RT" 0 KB 0 rows

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION

ORA-31684: Object type FUNCTION:"YJYB"."FORECASTINVALID" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETAIRCOLOR" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETAIRLEVEL" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETAIRTYPE" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETAQIVALUE" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETCOLOR" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETCONCENTRATION" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETFRACTIONALEXPONENTHOUR" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETPRIMARYPOLLUTANT" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETSTATIONTYPE" already exists

ORA-31684: Object type FUNCTION:"YJYB"."GETWINDDIRECTION" already exists

ORA-31684: Object type FUNCTION:"YJYB"."REMOVEINVALID" already exists

ORA-31684: Object type FUNCTION:"YJYB"."ROUND2" already exists

ORA-31684: Object type FUNCTION:"YJYB"."TESTSDVALUE" already exists

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

ORA-31684: Object type PROCEDURE:"YJYB"."ADD_JOB_HISTORY" already exists

Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

ORA-39082: Object type ALTER_PROCEDURE:"YJYB"."ADD_JOB_HISTORY" created with compilation warnings

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Job "YJYB"."SYS_IMPORT_FULL_01" completed with 17 error(s) at Thu May 26 19:25:16 2016 elapsed 0 00:23:37

[oracle@yjyb-db1 dmp]$

0 0