| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: EXPORT File Format / Export API
On Wed, 29 May 2002 19:33:39 GMT, "Tim Smith" <x_at_x.com> wrote:
>Tool wouldnt include source?
>
>> True - but the format isn't all that cryptic. A bit of work with a
>> binary editor will enable you to figure out enough to do what you want
>> to do.
>>
>> Thats what we did for our DBATool freeware - and the approach was
>> quite successful.
No we haven't released the source for it. However, the source wouldn't be much use to you as it is designed to read an export file created with the rows=N option and you (presumably) want to write exp files with data in them. Our code spends a lot of time moving back and forth picking DDL out of the export file and interpreting it whereas you would only need to emit information in sequence. The problems are quite different and the code would not be transferrable.
Basically tables are pretty much written in the export file in obvious clear ASCIIZ - with a statement or two before them to indicate the schema the table is to be created in. Data immediately follows the table. We have not developed any code which interprets the data since it was not relevant. We also never needed to interpret much of the leading header of the export file - you will probably have to figure that out.
Regards
Dale
 |
 |