Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loading data from Unix to NT tables
The easiest way would be to export your data from mysql to a delimited format, say '|' delimited. Then use SQL*Loader to import the data. There are a few examples in the Oracle Utilities guide on how to import.
Phil Bolduc
North Vancouver, BC Canada
In article <81ugok$eoa$1_at_bcarh8ab.ca.nortel.com>,
"Dilgeet Badial" <badial_at_nortelnetworks.com> wrote:
> Has anyone any experience with exporting data from Unix to PC. The
database
> on PC side is using msql database and on PC, I have installed Oracle.
I have
> some documentation on SQL loader but it tells me that I should use
> conventional Path loads. It however does not tell how to use it.
>
> Any suggestions. Which is the best way of doing this efficiently ??
>
> Dilgeet Badial
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Nov 29 1999 - 14:57:38 CST