November 4, 2003 at 2:39 pm
Hi All,
I am trying to export tables with data from the SQL
Server 2000 to Oracle 9i using a SQL to Oracle ODBC
driver. (Microsoft OLE DB Provider for ODBC Drivers)
I using the export option in the Enterprise manager to
do the same.
Using the export option, i was able to migrate the table with data for few tables.
The Dts package of the export wizard first creates the table in oracle and then migrates data into it.
During such an export, two tables out of 20 failed to migrate
saying that there is an EXCEPTION_ACCESS_VIOLATION
The below is the exact description of the error message that i am getting
"Need to run the object to perform this operation"
"Code excecution exception: EXCEPTION_ACCESS_VIOLATION"
and the export of the table data failed, though the
tables got created in the Oracle.
Any pointers as to why this is happening?
Thanks for your time and help,
-Sathish
November 5, 2003 at 11:49 am
First of all I would not use DTS to move data into Oracle as it does not do that efficiently.
That being said, make sure your tables are architecturally "clean." The failure could be related to index or constraint creation that is not compatable with Oracle.
Hope that helps,
Steve Hughes
Magenic Technologies
November 5, 2003 at 12:22 pm
Thanks for the response
Is there any better way to transfer the data from teh SQL.
We tried the OMWB but it does not export the multibyte chars in the desired format(UTF8) into oracle.
Please guide if you know a better way to acheive the same
Thanks,
-Satish
quote:
First of all I would not use DTS to move data into Oracle as it does not do that efficiently.That being said, make sure your tables are architecturally "clean." The failure could be related to index or constraint creation that is not compatable with Oracle.
Hope that helps,
Steve Hughes
Magenic Technologies
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply