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 220.127.116.11.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 :(