help with Oracle DUL unpump

I am trying to use DUL unpump to extra data from a corrupted data pump export file. I need some help with getting the
correct DDL from the unpump stream header output.

Questions:
1.) What is the column type of “<TYPE_NUM>101</TYPE_NUM> ” ?
2.) Is the following column Varchar2(255) ? Notice LENGTH=510 and does not match CHARLENGTH.
<NAME>PAYER_ID</NAME><TYPE_NUM>1</TYPE_NUM><LENGTH>510</LENGTH>…..
<CHARLENGTH>255</CHARLENGTH>

 

Type 101 is most likely a binary double, 8 bytes that together are an ieee double, no idea of those are native or in byte comparable order.

这位作者还没有填写简介。

查看所有文章

发表评论

Your email address will not be published. Required fields are marked *