sybase to Oracle migration [message #430221] |
Mon, 09 November 2009 09:56 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sundarfaq
Messages: 235 Registered: October 2007 Location: Chennai
|
Senior Member |
|
|
Hi,
I have converted sybase database objects like tables,view,stored procedure,store functions,trigger into oracle database using oracle sql devloper.
I have moved all data from sybase into oracle database using online data moving methods.but i unable to move the data from sybase to oracle database.i faced the problem like
the all the control file,pre load and post sql file generated but data file is not generated. During the sql loader process, it shows the error
SQL*Loader-500: Unable to open file (dig.dbo.AIRPORT_GROUP_AIRPORT.dat)
SQL*Loader-553: file not found
SQL*Loader-509: System error: The system cannot find the file specified.
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
I have checked the current location,the data file is not generated.
Please help me how to resolve this issue?
Thanks,
Michael.
|
|
|
Re: sybase to Oracle migration [message #430255 is a reply to message #430221] |
Mon, 09 November 2009 15:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Perhaps I have misread the question, but - are you, by any chance, using SQL*Loader to extract data from Sybase? The following sentence sounds like that:Quote:I have checked the current location,the data file is not generated. If so, bad news for you: SQL*Loader is a tool which loads data (from a file) into the Oracle database, not vice versa.
Also, what does that mean:Quote:I have moved all data from sybase into oracle database using online data moving methods.but i unable to move the data from sybase to oracle database So, did you move it or not? "I moved but I'm unable to move" ?!?
|
|
|