Trying to convert access database using access 2010 on a 2000 access data base into an 11g database. I get a 3021 error I've seen this thread which explains that the the access system table privileges need to be updated. https://kr.forums.oracle.com/forums/thread.jspa?threadID=1077955, I seem to have the permission correct and still get the error. I'm using SQLDeveloper version 3.2.20.09. Is there anyway to determine what the invalid relation ship is?
If you just want the data try right click "copy to oracle" on the individual table or per access database.
This will migrate the data (but not most meta data such as foreign keys).
To my knowledge:
1/It does not require system table privileges.
2/It has not been tested on access 2010.