This content has been marked as final. Show 6 replies
What are you using for the connection between Oracle and MySQL ? Is the Database Gateway for ODBC (DG4ODBC) ? If not, then what are you using ?
If you are using PL/SQL for the insert statements then you could add a counter for every insert statement then issue a commit when the counter reaches a certain value.
If this doesn't make sense then post the PL/SQL you are using and we maybe able to help further.
There is no connection between Oracle and MySQL . I want to use PL/SQL to connect to Oracle and select & concat out lots of insert statements to a SQL file and then import the SQL file to MySQL by mysql command .
Yes , I am using PL/SQL and it has a Export Tables tool . But I find it can only export all the table fields and the insert SQL can not be defined .
Of cause , I can modify the SQL file by Unix command , but I wonder if I can get a better method .
Thanks for the clarification.
As this is a problem using PL/SQL itself it would be better to ask the question in the PL/SQL forum here -
PL/SQL and SQL
They will have more experience of using PL/SQL itself to do what you want.
Thanks for your patient reply .
Do you have a good method to export data with commit every N rows in SQLPLUS ? I think it's better to implement in SQLPLUS .
WangHao,1 person found this helpful
If I understand correctly this is what you want to do -
- create insert statements from data in Oracle tables
- run these insert statements directly in MySQL using the MySQL equivalent of SQLPLUS
- you want the insert statements to have a commit after 'x' number of rows
If this is the case I still think the best option is to raise it in the SQL-PL/SQL forum.
The issue is creating the insert statements and adding an 'commit' statement after a number of rows.
I would have thought depending how you write the insert statements it should be possible to have some of counter and add a 'commit' statement after a number of rows.
Try the SQL-PL/SQL forum for further advice on the best way to do this.
Thanks for your generous answers . Maybe Oracle or SQL is not good at this work .
I think it's also a good method to finish the work using Unix command .
I will also try to find out how the PL/SQL implements it .