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

Migrating data from Access 2000 to oracle 9i

P: 8
Hi everyone, am a newbie and need help moving data back to
oracle from access.
There is an odbc link between access 2000 and oracle 9i
using the export command in access copied a complete table
with data to excel so that a user could edit it (delete and add records), I imported the edited table to access and want
to replace the linked oracle database in its entirety with the edited access version and don't know how to go about it.
It should be noted that the Linked table is just a table with
2 index keys and no queries and thats it. I can't change the name of the linked table since it is being used in the network.
What is the best way of replacing the oracle linked table without changing users or table name.
I tried migrating with SQL developer without success, there
was an error and on top of that a new user was created.
Please help me, any input will be highly appreciated
Thanks
Massamiya
Aug 8 '10 #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.