| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Weid exp/imp problem
This
error is coming because at the time of adding foreign key constraint ,
referencing primary key is not available.
You
can avoid this error by creating a similar schema in the user in which you are
taking the import and then import data
with
parameter "ignore=Y".
<SPAN
class=769511710-19122001>
<SPAN
class=769511710-19122001>
<SPAN
class=769511710-19122001>Kranti
<FONT face=Tahoma
size=2>-----Original Message-----From: Daiminger, Helmut
[mailto:Helmut.Daiminger_at_KirchGruppe.de]Sent: Wednesday, December
19, 2001 1:55 PMTo: Multiple recipients of list
ORACLE-LSubject: Weid exp/imp problem
Hi!
I'm experiencing a weird problem here... I'm about to move one
user's object from the development box to a test box. The user's rights on
both boxes are identical.
What I do is this: - export user
(using exp) from development. Works flawlessly. -
import user into the other box (user setup and tablespaces are
identical)
An I get the following errors which doesn't make a lot of
sense to me... ... . .
importing
table
table
table
table
 |
 |