Hi There are many ways to convert an Oracle DB to MySQL.
1 - Scan, process Oracle exp files, very painful 2 - Use a tool that can access both databases, ie Excel via ODBC 3 - Access oracle schema tables, user_tables, user_tab_columns, user_objects etc and create a MySQL SQL file. The third approach is probably the best, and will allow you to handle the differences between Oracle and MySQL, ie Oracle DATE field, SEQUENCES etc Check the Perl-DBI mail list archive and the web. There are scripts that will do this conversion for you. Simon On Tuesday 11 February 2003 7:20 am, rajesh wrote: > my previous database was ORACLE8 IN WHICH THE BACKUPS ARE .DMP FILES > > PLEASE HELP ME TO CONVERT THAT INTO MYSQL DATABASE > > > > PRATHIMA RAO > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Simon Windsor Email: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07720 447385 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
