Re: Oracle export file binary format

On Thu, 27 Apr 2000 22:14:47 GMT, Allan Plesniarski <aplesnia_at_my-deja.com> wrote:

>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
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat Apr 29 2000 - 00:00:00 CDT