Oracle export file binary format 
Author Message
 Oracle export file binary format
Hi, rather than pay a hefty license fee,
I have decided to write a utility that can read an Oracle export file
and perform a multi-stream import.  It is just a shame to see a 24
processor S80 chugging along on one CPU.

Does anyone have any documentation on the binary format of Oracle
export files?  Any leads will gain a complimentary copy of the utility.

Thanks,
Allan

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 Oracle export file binary format

On Fri, 28 Apr 2000 0:14:47 +0200, Allan Plesniarski wrote

Quote:
> Hi, rather than pay a hefty license fee,
> I have decided to write a utility that can read an Oracle export file
> and perform a multi-stream import.  It is just a shame to see a 24
> processor S80 chugging along on one CPU.

> Does anyone have any documentation on the binary format of Oracle
> export files?  Any leads will gain a complimentary copy of the utility.

Hi Allan,

if you want you can get expload. It is a nice starting point. I made it to do
just what you want but never completely finished it. (lack of time and
priority)

--
Ronald

certified oracle dba/ unix sa
http://home.wxs.nl/~ronr/professional.html



Wed, 18 Jun 1902 08:00:00 GMT
 Oracle export file binary format



Quote:
> Hi, rather than pay a hefty license fee,
> I have decided to write a utility that can read an Oracle export file
> and perform a multi-stream import.  It is just a shame to see a 24
> processor S80 chugging along on one CPU.

> Does anyone have any documentation on the binary format of Oracle
> export files?  Any leads will gain a complimentary copy of the utility.

> Thanks,
> Allan

> Sent via Deja.com http://www.deja.com/
> Before you buy.

What about using multiple db writers and/or other parallel facilities?

And of course the format of a dump file is propietary, so you won't be able
to write it, without being sued.

Hth,

Sybrand Bakker, Oracle DBA



Wed, 18 Jun 1902 08:00:00 GMT
 Oracle export file binary format
On Thu, 27 Apr 2000 22:14:47 GMT, Allan Plesniarski

Quote:

>Hi, rather than pay a hefty license fee,
>I have decided to write a utility that can read an Oracle export file
>and perform a multi-stream import.  It is just a shame to see a 24
>processor S80 chugging along on one CPU.

>Does anyone have any documentation on the binary format of Oracle
>export files?  Any leads will gain a complimentary copy of the utility.

There was a document put out by ORACLE about 10 years ago explaining
the format of the export file.  This was about the same time as V6/V7
transition.  Dunno if still available.  I have a copy somewhere in my
stash in the garage, but haven't seen it in years.

You can do something:

Import with ROWS=N, INDEXES=N, GRANTS=N.  That gets you an empty
schema.  Now, run a script to set all your tables to default parallel
of 2 or 3.  Then run the import with ROWS=Y, rest =N. This should get
you parallel inserts if you running V8.1.

Then run an import with INDEXFILE=<some file.sql>.  Edit this file to
put parallel option for the CREATE INDEX statements.  If you run UNIX,
'vi' can edit this.

Then run the script.  Finally,  run a final import with ROWS=N,
INDEXES=N and GRANTS=Y to get all the niceties in.

If you have lots of PK/FK constraints and triggers, you may have to
run a few scripts to get rid of them while the intermediate imports
are going on.  

It's surprising how fast this can be.  Looks like a lot of work, but
can be scripted and provides an interim solution.

Cheers
Nuno Souto

http://www.users.bigpond.net.au/the_Den/index.html



Wed, 18 Jun 1902 08:00:00 GMT
 Oracle export file binary format
Much of the information about the export file can be viewed by opening it
in a hex editor, however, if you are going to build an import tool, it
might be worth considering building an export tool as well that uses an xml
or sgml format.  Then you could use the tools to migrate data between
databases as well as load into Oracle.

Such an xml export might also be valuable to load structural information
into design tools such as argo/uml if xmi is used as the xml dtd.

Frank Hubeny

Quote:

> Hi, rather than pay a hefty license fee,
> I have decided to write a utility that can read an Oracle export file
> and perform a multi-stream import.  It is just a shame to see a 24
> processor S80 chugging along on one CPU.

> Does anyone have any documentation on the binary format of Oracle
> export files?  Any leads will gain a complimentary copy of the utility.

> Thanks,
> Allan

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. EXPORT File Format / Export API

2. Oracle Export File Format

3. Oracle Export File Format

4. Oracle Export File Format

5. Export Binary image in SQL server table into a jpg file

6. binary file import/export via stored procedure?

7. How to export an Access table to a binary file in Visual Basic

8. help info for binary file format for sql micrisoft

9. COPY BINARY file format proposal

10. COPY BINARY file format proposal

11. COPY BINARY file format proposal

12. VB Binary File Format


 
Powered by phpBB® Forum Software