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

export dumpfile -> sqlload conversion ?

From: Ronald <ronr_at_wxs.nl>
Date: Thu, 29 Oct 1998 20:10:15 +0100
Message-ID: <01HW.B25E7C270009277202447DC0@news.wxs.nl>


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 Thu Oct 29 1998 - 13:10:15 CST

Original text of this message

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