In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Environment description:
Today, from the 4A remote computer copy dmp file, because the file is too large, copy action can not be completed, so filesize specify the output file size, and then compress.
[oracle@mobile61 dpdump] $expdpmobile/mobile directory=DATA_PUMP_DIR dumpfile=UserBoss_20160619_25%U.dmptables=mb_dw_user_data:part_20160619_14,mb_dw_user_data:part_20160620_14,mb_dw_user_data:part_20160621_14,mb_dw_user_data:part_20160622_14,mb_dw_user_data:part_20160623_14,mb_dw_user_data:part_20160624_14,mb_dw_user_data:part_20160625_14parallel=4 filesize=155096041 compression=all takes compressed files Assign Export according to the specified size of filesize: Release 11.2.0.4.0-Production onTue Jun 28 16:20:35 2016 Copyright (c) 1982, 2011, Oracle and/or itsaffiliates. All rights reserved. Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, OLAP, Data Miningand Real Application Testing optionsStarting "MOBILE". "SYS_EXPORT_TABLE_01": mobile/* directory=DATA_PUMP_DIRdumpfile=UserBoss_20160619_25%U.dmptables=mb_dw_user_data:part_20160619_14,mb_dw_user_data:part_20160620_14,mb_dw_user_data:part_20160621_14,mb_dw_user_data:part_20160622_14 Mb_dw_user_data:part_20160623_14,mb_dw_user_data:part_20160624_14,mb_dw_user_data:part_20160625_14parallel=4 filesize=155096041 compression=allEstimate in progress using BLOCKS method...Processing object typeTABLE_EXPORT/TABLE/TABLE_DATATotal estimation using BLOCKS method: 1.526GBProcessing object typeTABLE_EXPORT/TABLE/TABLEProcessing object typeTABLE_EXPORT/TABLE/ COMMENT. . Exported "MOBILE". "MB_DW_USER_DATA": "PART_20160619". "PART_20160619_14" 60.92 MB 1969793 rows. . Exported "MOBILE". "MB_DW_USER_DATA": "PART_20160621". "PART_20160621_14" 57.32 MB 1974124 rows. . Exported "MOBILE". "MB_DW_USER_DATA": "PART_20160620". "PART_20160620_14" 60.92 MB 1969793 rows. . Exported "MOBILE". "MB_DW_USER_DATA": "PART_20160623". "PART_20160623_14" 57.60 MB 1975622 rows. . Exported "MOBILE". "MB_DW_USER_DATA": "PART_20160625". "PART_20160625_14" 57.57 MB 1977708 rows. . Exported "MOBILE". "MB_DW_USER_DATA": "PART_20160624". "PART_20160624_14" 57.66 MB 1976510 rowsProcessing object typeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS. . Exported "MOBILE". "MB_DW_USER_DATA": "PART_20160622". "PART_20160622_14" 57.40 MB 1974954 rowsMaster table "MOBILE". "SYS_EXPORT_TABLE_01" successfully loaded/unloaded* * Dump file set forMOBILE.SYS_EXPORT_TABLE_01 is: / oracle/database/oracle/admin/mobile/dpdump/UserBoss_20160619_2501.dmp / oracle/database/oracle/admin/mobile/dpdump/UserBoss_20160619_2502.dmp / oracle/database/oracle/admin/mobile/dpdump/UserBoss_20160619_2503.dmp / oracle/database/oracle/admin/mobile/dpdump/UserBoss_20160619_2504.dmp / oracle/database/oracle/admin/mobile/dpdump/UserBoss _ 20160619_2505.dmpJob "MOBILE". "SYS_EXPORT_TABLE_01" successfully completed atTue Jun 28 16:21:06 2016 elapsed 0 00:00:31
Expdp mobile/mobiledirectory=DATA_PUMP_DIR dumpfile=UserBoss_20160619_25%U.dmptables=mb_dw_user_data:part_20160619_14,mb_dw_user_data:part_20160620_14,mb_dw_user_data:part_20160621_14,mb_dw_user_data:part_20160622_14,mb_dw_user_data:part_20160623_14,mb_dw_user_data:part_20160624_14,mb_dw_user_data:part_20160625_14parallel=4 filesize=155096041 compression=all
Using tar-czf to compress again, the effect is not obvious.
The compression parameter is specified without the need for tar-czf
[oracle@mobile61 Tmpfile] $ll
Total 1234480
-rw-r- 1 oracle oinstall 123053127 Jun 28 17:17 2501.tgz
-rw-r- 1 oracle oinstall 124641280 Jun 28 16:21 UserBoss_20160619_2501.dmp
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.