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

[Surendra . Tirumala]

Title: RE: import from 8i to 9i /IMP-00003: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 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: import from 8i to 9i /IMP-00003: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 expressed in this email are strictly personal.
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-00003:ORA-02298

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.

Thanks,
Surendra