Urgent: Oracle-large tables-copy
843854Jun 24 2004 — edited Jun 25 2004Hello,
I'll appriciate a lot if somebody can help me solve this problem:
I'm using rdbthin.jar as driver on my client-pc an am trying to copy data from table in Oracle Rdb to table in MySQL with the same structure. When there a more then 500 rows in a result set, I become following exception:
java.sql.SQLException: in <rdbjdbcsrv:fetch>
%RDB-F-SYS_REQUEST, error from system services request
-COSI-F-CREATERR, cannot create file
-RMS-F-DEV, error in device name or inappropriate device type for operation
@rdb.Client.fillCache
@rdb.Client.fillCache
@rdb.Client.fillCache
at oracle.rdb.jdbc.common.Client.throwException(Client.java:3287)
at oracle.rdb.jdbc.common.Client.throwException(Client.java:3254)
at oracle.rdb.jdbc.common.Client.FetchRow(Client.java:863)
at oracle.rdb.jdbc.rdbThin.Rdb.FetchRow(Rdb.java:671)
an there are less datarows in the client then it must be.
I am retrieving now all rows and then insert them row by row in mysql-table.
Is there a way I get row by row or 500 rows an then other 500 better to solve this?
Thank you in forward!