Home » SQL & PL/SQL » SQL & PL/SQL » Oracle error (Oracle 10.2.0.3)
Oracle error [message #357020] Mon, 03 November 2008 10:07 Go to next message
Paul5
Messages: 2
Registered: November 2008
Junior Member
I am trying to migrate and Access database 2000 to Oracle database (version 10.2.0.3) with Oracle Migration Workbench.
Migration Workbench generated file <AccessDB_Name>.sql.
When I run the file on the Oracle database under the pre-created Oracle account I get the following error:


SQL> show user
USER is "SCO_RECCLUB"
SQL> REM This SQL script was generated by the Oracle Migration Workbench
SQL> REM Exporter for Microsoft Access on 22/10/2008 10:27:03
SQL> REM Release: 10.2.0.2.0
SQL> REM Version: Microsoft Access 2000
SQL> REM Do not modify this file as any modification will invalidate the export
SQL> REM and subsequent migration of your Microsoft Access database
SQL>
SQL> set define off
SQL> set verify off
SQL> set serveroutput on size 1000000
SQL> set feedback off
SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK
SQL>
SQL> begin
2
3 WWV_MIG_ACC_LOAD.INS_WWV_MIG_ACCESS (
4 p_dbid => 1,
5 p_dbname => 'rclub_be',
6 p_dbsize => '2338KB',
7 p_dbpathname => 'C:\Rec C DB\rclub_be.mdb',
8 p_dbuser => 'rclub_be',
9 p_dbpassword => ' ',
10 p_isappdb => 1,
11 p_isattacheddb => 0,
12 p_convertdb => 1,
13 p_jetversion => 4.0,
14 p_accessversion => 'MS Access 2000',
15 p_build => 211,
16 p_collatingorder => 1033,
17 p_querytimeout => 60,
18 p_startupform => NULL,
19 p_startupshowstatusbar => 0
20 );
21
22 end;
23 /
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (FLOWS_030100.WWV_MIG_ACC_FK) violated - parent key not found
ORA-06512: at "FLOWS_030100.WWV_MIG_ACC_LOAD", line 120
ORA-06512: at line 3


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

I am not sure how to proceed with the migration or if it is even possible at this stage. Any help or explanation of the error message above would be very much appreciated.

Paul
Re: Oracle error [message #357047 is a reply to message #357020] Mon, 03 November 2008 12:21 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Pretty self explanatory:
02291, 00000,"integrity constraint (%s.%s) violated - parent key not found"
// *Cause: A foreign key value has no matching primary key value.
// *Action: Delete the foreign key or add a matching primary key.
Re: Oracle error [message #357048 is a reply to message #357020] Mon, 03 November 2008 12:22 Go to previous messageGo to next message
bcteh
Messages: 2
Registered: October 2008
Junior Member
I have not experience on Oracle Migration Workbench.

But look at the message,
ORA-02291: integrity constraint (FLOWS_030100.WWV_MIG_ACC_FK) violated - parent key not found
ORA-06512: at "FLOWS_030100.WWV_MIG_ACC_LOAD", line 120
ORA-06512: at line 3

that is a reference key problem.
The data extracted by Oracle Migration Workbench didn't
follow the parent -> child sequence.
Check on Oracle Migration Workbench is that any setting
to force it follow the parent -> child sequence
Or drop the reference constraint at database
and recreate it after migration.

Regards
Teh

[Updated on: Mon, 03 November 2008 12:25]

Report message to a moderator

Re: Oracle error [message #357133 is a reply to message #357048] Tue, 04 November 2008 02:19 Go to previous messageGo to next message
Paul5
Messages: 2
Registered: November 2008
Junior Member
Thank you very much with your quick response. I will try both of your suggestions and get back to you if either worked.

Paul
Re: Oracle error [message #357137 is a reply to message #357133] Tue, 04 November 2008 02:34 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Next time, before posting, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Previous Topic: numbering different records of each patient
Next Topic: write the query result in file and send the file in email attachement.
Goto Forum:
  


Current Time: Wed Dec 07 14:37:17 CST 2016

Total time taken to generate the page: 0.09458 seconds