I have been trying to transfer an access database into oracle using the Oracle SQL Developer. I have used a tutorial (http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/msaccess/migrate_microsoft_access_otn.htm#p) and am getting errors on the last step when I run the oracle_ctl.bat file from Command Prompt. I get notified that tables have been altered, but prior to that there are errors logged for every table:
SQL*Loader: Release 18.104.22.168.0 - Production on Wed Jun 20 11:10:44 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-350: Syntax error at line 7.
Expecting "," or ")", found "accreditation_id".
I have located the data files (.dat files) in the same directory/folder as the sqldeveloper. Please help as I need this running ASAP :(
Edited by: 941870 on Jun 20, 2012 9:13 AM
Edited by: 941870 on Jun 20, 2012 10:13 AM