By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,460 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

Unable to migrate data from Access source to Oracle destination

P: 27
hi
I have migrated the Access 2003 database to Oracle 10g database by Oracle work

bench.
Actually i am using the platform is Microsoft Windows Server 2003 for migaration.

and i have configured OMWB with Access Plugins in Windows sever 2003.

Basically i have converted the Access database to XML file. then the oracle table

model is created. but the data's are not migrated to oracle table.

while am migrating to oracle. It's shows the following error message.

Database Name is oracle_migrate and the Table Name is amt_subj_tbl.

Unable to migrate data from source table "amt_subj_tbl" to destination table
oracle_migrate.AMT_SUBJ_TBL : oracle_migrate.AMT_SUBJ_TBL;[Microsoft][ODBC Microsoft Access Driver]"(Unknown)" is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides


Please anyone give me a Solutions as soon as Possible.

Thanks
Jan 25 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.