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: Kirtikumar Deshpande 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).
