1 Reply Latest reply: Jun 20, 2012 3:54 PM by 944873 RSS

    Migrating Access Database to Oracle: Syntax Errors

    944873
      Hi guys,

      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 11.2.0.1.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".
      accreditation_id 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 :(

      Thank you!

      Edited by: 941870 on Jun 20, 2012 9:13 AM

      Edited by: 941870 on Jun 20, 2012 10:13 AM