OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle error (Oracle 10.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle error [message #357020]

Mon, 03 November 2008 10:07

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

Report message to a moderator

Re: Oracle error [message #357047 is a reply to message #357020]

Mon, 03 November 2008 12:21

joy_division
Messages: 4963
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.

Report message to a moderator

Re: Oracle error [message #357048 is a reply to message #357020]

Mon, 03 November 2008 12:22

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

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

Report message to a moderator

Re: Oracle error [message #357137 is a reply to message #357133]

Tue, 04 November 2008 02:34

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 08:11:13 CST 2025