Re: FW: import from 8i to 9i /IMP-00003:ORA-02298

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 08 Jul 2003 11:15:54 -0700
Message-ID: <F001.005C3E1E.20030708110429@fatcity.com>

Surenda,
 When doing exports and imports of data tables that have constraints the order in which you export and import is critical for the constraints to work properly. The error listed says that it can't find the parent data. Was that table completely imported before the child was imported? Try importing one table at a time to verify that the export/import process is working peoperly. Does the existing data contain any special characters that are different between the different ASCII versions? Have you tried to exports with CONSTRAINTS=N and no constraints on the import tables and then add the constraints AFTER the data import?

Ron

>>> [EMAIL PROTECTED] 07/08/03 02:29PM >>> Hi Kirti,

As I have mentioned, my data is clean. I could import this data into an
existing 8i database.
Do you still think that importing data in two passes would fix it? Anything changed form 8i to 9i regarding iport process?

I tried catching the invalid data into excetions and did cross checking and
observed that
I have valid data. I mean to say I could not enable those failed constarints
manually as well.
Surprisingly my STATUS column in USER_CONSTARINTS tables reads 'ENABLED' for
those failed constarints also.

Am I missing something?

Thanks,
Surendra

-----Original Message-----
Sent: Tuesday, July 08, 2003 12:44 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]

I don't think this is related to NLS stuff...

02298, 00000,"cannot validate (%s.%s) - parent keys not found" // *Cause: an alter table validating constraint failed because the table has
// orphaned child records.
// *Action: Obvious

I suggest cleaning up target database (drop target tables, indexes, etc).
Re-Create all target tables (empty).
Do not enable constraints (disable them if already enabled).

Re-import with ignore=y, and then enable constraints.

Oracle imports tables in table_name order for the schema. Enabled RI constraints can pose a
problem.

• Kirti
  • [EMAIL PROTECTED] wrote:
    > Hello All,
    >
    > We are working on migrating 8i databases to 9i. As Sun boxes are not
    > available yet, I have decided to do some experiments on my PC. I am
    trying
    > to import into 9i database using export dump file of 8i database. I
    have my
    > 8i database created in US7ASCII and I have created 9i database also
    in
    > US7ASCII with UTF8, just to make sure that I won't hit any
    conversion
    > issues.
    > When I tried to import the data into this newly created database it
    is
    > giving me some strange "ORA-02298: cannot validate
    (CMS.FK_OF_VS_SYSID) -
    > parent keys not found" errors.
    > I have verified that the data in 8i database is valid.
    >
    > I have successfully imported into an existing 8i database with no
    problem. I
    > am wondering if the Character set conversion the import utility is
    doing
    > making any difference.
    >
    > The following are the messages I am getting when I invoked import:
    >
    > ==============
    > import done in WE8MSWIN1252 character set and UTF8 NCHAR character
    set
    > import server uses US7ASCII character set (possible charset
    conversion)
    > export client uses US7ASCII character set (possible charset
    conversion)
    > export server uses US7ASCII NCHAR character set (possible ncharset
    > conversion)
    > ==============
    >
    >
    > I have gone through the globalization support guide and concluded
    that I
    > should not worry about charctersets if I am not using any special
    datatypes
    > or NCHAR datatypes.
    >
    > Please advise me how to resolve this issue. Is character set any
    issue at
    > all?
    > Do I have to influence the import utility to use the characterset of
    my
    > interest?
    > I don't want to do this as I will have to do this each time I
    import.
    >
    > I am wondering if any bug is associated with this.
    > Thanks for your help.
    >
    > Surendra
    > --
    > Please see the official ORACLE-L FAQ: http://www.orafaq.net
    > --
    > Author:
    > INET: [EMAIL PROTECTED]
    >
    

    ---

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: 
  INET: [EMAIL PROTECTED] 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jul 08 2003 - 13:15:54 CDT