www.Orasql.Com
 
用户名: 密码:  验证码: 注册|找回密码 oracleawen's blog  
 
         当前位置 >> 技术论坛  发表帖子     论坛版块     查找帖子
压缩表用expdp导出还能压缩2/3左右-技术论坛||Oracle高手之路—Orasql.Com!
            压缩表用expdp导出还能压缩2/3左右
 
发贴人:oracle_awen
oracleawen@gmail.com448315233127.0.0.1
用户级别:管理员
发贴总数:1245
注册时间:2011-05-05 09:23:03
2011-06-01 08:15:45
压缩表用expdp导出还能压缩2/3左右 和gzip差不多 sql> select segment_name,sum(bytes)from user_segments where segment_name like'lt%' group by segment_name; segment_name sum(bytes) --------------------------------------------------------------------------------- --------------- lt_v931_1 56222482432 lt_v931 32162054144 [oracle@ora1d/oradata/ytbdb/hb]#>expdp rkdata/rkdata dumpfile=v931%u.dmp logfile=v931.log tables=lt_v931 directory=dir compression=all parallel=16 export release 11.2.0.1.0 - production on mon feb 21 161551 2011 copyright (c) 1982, 2009, oracle and/or its affiliates. all rights reserved. connected to oracle database 11g enterprise edition release 11.2.0.1.0 - 64bit production with the partitioning, olap, data mining and real application testing options starting "rkdata"."sys_export_table_01" rkdata/ dumpfile=v931%u.dmp logfile=v931.log tables=lt_v931 directory=dir compression=all parallel=16 estimate in progress using blocks method... processing object type table_export/table/table_data total estimation using blocks method 29.95 gb processing object type table_export/table/table processing object type table_export/table/index/index processing object type table_export/table/constraint/constraint processing object type table_export/table/index/statistics/index_statistics . . exported "rkdata"."lt_v931" . . master table "rkdata"."sys_export_table_01" successfully loaded/unloaded dump file set for rkdata.sys_export_table_01 is /oradata/ytbdb/hb/v93101.dmp ... job "rkdata"."sys_export_table_01" successfully completed at 162101 705601536 feb 21 1621 v93101.dmp 597987328 feb 21 1621 v93102.dmp 639160320 feb 21 1621 v93103.dmp 527728640 feb 21 1621 v93104.dmp 624365568 feb 21 1621 v93105.dmp 558358528 feb 21 1621 v93106.dmp 602599424 feb 21 1621 v93107.dmp 603152384 feb 21 1621 v93108.dmp 667500544 feb 21 1621 v93109.dmp 632102912 feb 21 1621 v93110.dmp 665309184 feb 21 1621 v93111.dmp 607301632 feb 21 1621 v93112.dmp 546308096 feb 21 1621 v93113.dmp 585662464 feb 21 1621 v93114.dmp 584294400 feb 21 1621 v93115.dmp 618991616 feb 21 1621 v93116.dmp

      
 
  
 Orasql.Com|E-Mail:oracleawen@gmail.com|Phone:15271942915|Copyright © 2011|All Rights Reserved|