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 dumpfile -> sqlload conversion ?

Re: export dumpfile -> sqlload conversion ?

From: John P. Higgins <jh33378_at_deere.com>
Date: Fri, 30 Oct 1998 09:46:14 -0600
Message-ID: <3639DF46.9CD59A6D@deere.com>


Sam Youngman presented a paper on the export file format at IOUW '96. It didn't make it onto the CDROM, so all I have is a hardcopy.

Sam's phone is listed as 1-800-DBMS-PRO.

Ronald wrote:

> Hi there !
>
> we have exp direct=y that's fast
> we have sqload direct=y that's fast too
>
> we don't have imp direct=y that's a pity.
>
> Has anybody tried to convert the data in the export.dmp file to a format
> suitable for sqlload ? I think it could save lots of time since sqlload can
> read tables in direct path and in parallel.
>
> What format is the data in export.dmp in ? When I know that, it should not be
> too difficult to write a little program to create the control-files and
> datafiles.
>
> Ideas ? comments ? sources ?
> --
> Ronald
>
> ---------------------------------------------------------------------------
> mailto:ronr_at_wxs.nl
> http://home.wxs.nl/~ronr/RonR.html (last update: june 8th, 1998)
> http://www.maccentral.com/news/9804/migration.shtml (forward migration home)
>
> I think so I mac !
Received on Fri Oct 30 1998 - 09:46:14 CST

Original text of this message

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