| 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
You
may need to use consistent=y on the export to ensure that the view for the
entire export run is from one snapshot in time. If your application is
busy changing data during the export, then as export moves through the list of
tables (alphabetically I think) then you'll get some tables at the beginning of
the list from one time, and tables late in the list from another with possible
referential problems just as exhibited below.
<FONT face=Arial color=#0000ff
size=2>
hope
this helps,
<FONT face=Arial color=#0000ff
size=2>Steve
<FONT face=Tahoma
size=2>-----Original Message-----From: Daiminger, Helmut
[mailto:Helmut.Daiminger_at_KirchGruppe.de]Sent: Wednesday, December
19, 2001 2:25 AMTo: 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
 |
 |