Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: MySQL conversion
Aditya Alurkar wrote:
>Since MySQL allows you to "dump" data directly to CSV files you can always
>dump the data and use something like SQLoader to import it into oracle, if
>you want to get all fancy perl would be good choice to move the data/maybe
>even create the tables.
>
>A quick google search resulted in http://iheavy.com/node/51 which seems like
>a good starting point as well
>
>
>
>
I would also recommend that way (CSV files) - I think it is possible to
attach CSV files as external tables
directly to Oracle (and doing the rest with Oracle SQL by simple CREATE
AS SELECT)
for example http://www.adp-gmbh.ch/ora/misc/ext_table.html
or http://www.oracle.com/technology/pub/articles/10gdba/week16_10gdba.html
regards
Remigiusz
-- --------------------------------------- Remigiusz Sokolowski <rems_at_wp-sa.pl> WP/PTI/DIP/ZAB (+04858) 52 15 770 MySQL v. 4.x Oracle v. 10.x --------------------------------------- -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 10 2006 - 06:18:13 CDT
![]() |
![]() |