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
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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]$