Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: EXPORT File Format / Export API

Re: EXPORT File Format / Export API

From: Tim Smith <timsmith_s_at_xhoo.com>
Date: Thu, 30 May 2002 15:59:28 GMT
Message-ID: <A%rJ8.119173$L76.199731@rwcrnsc53>


Thank you for the help. I will check out your tools too! Thanks again.

"Dale Edgar" <Dale_at_DataBee.com> wrote in message news:3cf5caf9.1598859_at_news.btclick.com...
> 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
> -----------------------
> DataBee: Small referentially correct subsets of large databases for
> development, testing and training. http://www.DataBee.com
Received on Thu May 30 2002 - 10:59:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US