:[EMAIL PROTECTED]Sent: Monday, July 14,
2003 10:05 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: import from 8i to 9i
/IMP-3:ORA-02298
Just to update you all...
I am not having any problems if I setup a
db link from 9i to 8i and get the data then enable
-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July
09, 2003 11:59 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: import from 8i to 9i
/IMP-3:ORA-02298
I did that already. Please see
below..
ERROR 1:
=
IMP-00017: following statement
ORACLE-LSubject: RE:
import from 8i to 9i /IMP-3:ORA-02298
Could your export file be corrupt. There have been a few alerts
on 8.1.7 exports producing bad dump files. One alert is
Note:223399.1.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland
Regional
I suggest calling Oracle Support. Get a test case ready.
Please post how the problem gets resolved.
- Kirti
--- [EMAIL PROTECTED] wrote:
I tried it on my sun box, still same problem.
Also I tried with no compressing/uncompressing of dmp file, no luck.
-Original Message-
: Wednesday, July
09, 2003 11:14 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: import from 8i to 9i
/IMP-3:ORA-02298
I tried it on my sun box, still same
problem.
Also I tried with no
compressing/uncompressing of dmp file, no luck.
-Original
Message
When all else fails...
Log a TAR with Oracle
Sit back and wait, while enjoying a few belts of quality Kentucky sipping Bourbon
Read through the phone book and locate all the Ursulas in the greater Frankfort area...begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
I have opened TAR this morning.
Sure, will let you know.
Thank you all for your time.
Surendra
-Original Message-
Sent: Wednesday, July 09, 2003 11:30 AM
To: Multiple recipients of list ORACLE-L
I suggest calling Oracle Support. Get a test case ready.
Please post how the problem
;
No rows.
-Original
Message-From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 09, 2003
10:37 AMTo: '[EMAIL PROTECTED]'Cc:
'[EMAIL PROTECTED]'Subject: RE: import from 8i to
9i /IMP-3:ORA-02298
Surendra,
Go back to
the 8i database
I tried importing data first then enabling constraints, same problem.
I have disabled(it is not enabled to begin with but reporting 'ENABLED' in
USER_CONSTRAINTS) one of those constraints and tried to enable it manually.
Same error.
And I have checked the data again. It is having parent keys.
Title: RE: import from 8i to 9i /IMP-3:ORA-02298
What userid is exporting data and importing data? Try exporting and importing as system.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
Are your sure that the parent table data is getting imported fully? Number of exported
rows match
the number of imported rows?
During your subsequent import attempts, are you truncating the table?
- Kirti
--- [EMAIL PROTECTED] wrote:
I tried importing data first then enabling constraints,
. QOTD: Any clod can have facts, having an opinion is an art !
-Original Message- From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 08, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject:
RE: import from 8i to 9i /IMP-3:ORA-02298
I tried importing data
Title: RE: import from 8i to 9i /IMP-3:ORA-02298
Hi
Raj,
First
I tried doing as a DBA user now I tried using SYSTEM. But still the same
problem.
Thanks,
Surendra
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003
3:34 PMTo
Yes, I am sure. Just to make sure, I have compared the counts from export
log file and import log file. Also I compared it with import log file I did
in to 8i database.
What I did with two pass import is..first I have imported with constarints=n
then I imported with ROWS=N CONSTARINTS=Y. So I am
Sorry..I forgot to write the query...
select count(*) from twesvs
where VS_OFF_SYSID not in (select OF_OFF_SYSID from TWESOF);
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 5:10 PM
To: Multiple recipients of list ORACLE-L
Yes, I am sure. Just to make sure, I
if the problem is between Unix and Windows.
Thanks for your reply.
Surendra
-Original
Message-From: Jeffrey Beckstrom
[mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 3:59
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
import from 8i to 9i /IMP-3:ORA-02298
Could
Can u check in source database if the constraint is set to enable novalidate
. It might have some data integrity problem in old data .
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 2:09 PM
Yes, I am sure. Just to
Run the following command after both tables are loaded and the constraint is not
enabled
select vs_off_sysid
from cms.twesvs
where vs_off_sysid not in (select of_off_sysid from cms.twesof);
[EMAIL PROTECTED] wrote:
Yes, I am sure. Just to make sure, I have compared the counts from export
I did that.
-Original Message-
Sent: Tuesday, July 08, 2003 5:45 PM
To: Multiple recipients of list ORACLE-L
Run the following command after both tables are loaded and the constraint is
not enabled
select vs_off_sysid
from cms.twesvs
where vs_off_sysid not in (select of_off_sysid from
I don't think this is related to NLS stuff...
02298, 0,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,
20 matches
Mail list logo