Re: Move SQL Server Tables to Oracle

No it doesn't, sqlldr probably uses OCI... or in some cases maybe even lower-level layer, UPI (user program interface).

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 19, 2003 1:19 AM

> Ken,
>
> Could you please elaborate on how SQL*Loader uses SQL*Plus?
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com
>
>
>
> -----Original Message-----
> KENNETH JANUSZ
> Sent: Thursday, September 18, 2003 3:40 PM
> To: Multiple recipients of list ORACLE-L
>
> That will work as long as they are sets of tables are the same layout.
> If
> not, then you have to map from SQL Server to Oracle which could be a
> complex
> time consuming task. Then the best bet is to generate delimited flat
> files
> from SQL Server and use SQL*Loader to load them into Oracle. For this I
> recommend the book: SQL*Loader, The definitive Guide by Gennick &
> Mishra.
>
> Sorry to say it SQL*Loader uses SQL*Plus, not Perl.
>
> My $0.02 worth,
>
> Ken Janusz, CPIM
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, September 18, 2003 2:59 PM
>
>
> >
> > If you are familiar with Perl and DBI, you can pre-create
> > the tables in Oracle, open a connection to both the MS
> > and Oracle databases, select from MS, insert to Oracle.
> >
> > Do it all in one step, it's pretty straightforward.
> >
> > Jared
> >
> > On Thu, 2003-09-18 at 00:59, Gunnar Berglund wrote:
> > > Hi all,
> > >
> > > I need to move some sql server tables to oracle.
> > >
> > > Do you have some ideas how to do it. I have no idea ...
> > >
> > > rgds
> > > G
> > >
> > >
> > > ---------------------------------
> > > Want to chat instantly with your online friends? Get the FREE
> Yahoo!Messenger
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: KENNETH JANUSZ
> INET: kjanusz_at_att.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Igor Neyman
> INET: ineyman_at_perceptron.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).