Discussions
Categories
- 384.6K All Categories
- 2.5K Data
- 556 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 562 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 167 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 537 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
SQL Developer - Migrate Access to Oracle
Attempting to migrate a MS Access (accdb) database to Oracle 10g.
Using SQL Developer Version 4.0.0.12 Build MAIN-12.84. Tools, migration, migrate.
Step 1, use the stand alone MS Access export tool to generate file to use in offline capture mode (omwb2007).
Step 2, repository schema set up in Oracle for the model.
Step 3, Migrate, migration and follow the wizard, using the offline option and pointing to step 1.
Including data.
First run generated an error, taken from MIGRLOG table, last 3 rows:
NullPointerException, Capture
Convert,null
Performing column default clause translation: FAILED : Database Migration : FAILED
Checked the XML file generated by step 1 and the log file generated from step 3. Looked at the Access database and removed some queries that were not required. Also removed modules and macros.
Ran through the steps again.
The process failed again, curiously at the same point, exactly the same number of rows in the log table, even though a different number of queries in MS Access on second run.
Ideas, thoughts appreciated