| IMPORT [message #73569] |
Tue, 25 May 2004 03:08  |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Dear Friends,
I am facing problem during Import.During Import of the Dump file the errors which I get are "ORA-00942 ENCOUNTERED","USER DOES NOT EXIST","SKIPPING TABLE"
and at the end "ABNORMAL END OF IMPORT PROCEDURE".
I think the problem is due to Foreign key constraints on Tables.But,I have tried "CONSTRAINTS=N" parameter but that also doesn't work.
Can anybody tell me if there is any procedure or command through which We can disable the Constraints at Database Level during Import and Enable them afterwards.
Is there any kind of adjustment required while Importing from .DMP file of 8.1.5 VERSION TO 9.0.1. As the Export was taken on Oracle VERSION 8.1.5
KINDLY HELP ME ON THIS.
MILIND.
|
|
|
|
| Re: IMPORT [message #73571 is a reply to message #73569] |
Tue, 25 May 2004 03:54  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
if so, try importing the specific user!.
recreate the specific user if required.
imp dba/password file=somedumpfile.dmp fromuser=sourceUser touser=targetuser
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
