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.


Posted

in

by

Tags:

Comments

Leave a Reply

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