ITPub博客

expdp/impdp实例 详细http://sgadba.blog.163.com/blog/static/1370466602011112113862/[@more@]

IMP-00032: SQL statement exceeded buffer lengthIMP-00008: unrecognized statement in the export file: 'This table defines the category names available for a metric class.'IMP-00032: SQL statement exceeded buffer lengthIMP-00008: unrecognized statement in the export file: 'This table provides information about what category is applicable for a given metric/policy guid and metric class. The same table is used to define mappings for both metrics and policies.'....resolve: add parameter buff

1, exp direct=y recordlength=65535 IN direct mode, exp does comparable performance as expdp. Just the dump file larger round 15% .2, imp commit=y recordlength=65535 buffer=10485760imp does the essentially different way as impdp . For imp, it always does a convertional import, Never direct load. For impdp, it does the direct load.So the test result is as expected: impdp is much faster than imp. 2 times faster or Evern great.-- parameter of imp which about indexindexes=yes => imp execute index

oracle 11G enhancement:expdp remap_dataimpdp : remap_data is only effectively in network import mode.http://hi.baidu.com/ipeipei/blog/item/5cb74aed93fd5cd8b31cb1fb.htmlhttp://www.newsmth.net/pc/pccon.php?id=2206&nid=353494注意：function return value should have the same datatype as the input parameter ,which is same to the mask value datatype.[@more@]