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: Loading data from Unix to NT tables

Re: Loading data from Unix to NT tables

From: <pbolduc_at_my-deja.com>
Date: Mon, 29 Nov 1999 20:57:38 GMT
Message-ID: <81upbv$3rq$1@nnrp1.deja.com>

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

Original text of this message

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