7 x 24 在线支持!
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.