Home » RDBMS Server » Server Utilities » Import not successful
Import not successful [message #69900] Mon, 18 March 2002 20:07 Go to next message
Faraz
Messages: 5
Registered: April 1999
Junior Member
I made an export file using user MDADM and now trying to import the expdat.dmp using user AZFAR1. the command i use is
imp AZFAR1/AZFAR1 FULL=Y
but the problem is it imports all the tables and the gives the message import completed without any errors. but it is not importing the constraints. And the constraints are in the dmp file. Please help me as it is urgent and my job is in danger. the dmp file made was from 8.1.6 and i am also using 8.1.6. so therefore no version error. PLEASE PLEASE HELP ME!!!

Report message to a moderator

Re: Import not successful [message #69901 is a reply to message #69900] Mon, 18 March 2002 20:35 Go to previous messageGo to next message
Carnage
Messages: 9
Registered: March 2002
Junior Member
use command
imp AZFAR1/AZFAR1 fromuser=MDADM touser=AZFAR1

Report message to a moderator

Re: Import not successful [message #69919 is a reply to message #69900] Tue, 19 March 2002 22:47 Go to previous message
Vijay
Messages: 116
Registered: September 1999
Senior Member
Hi,
Try importing with the parameter CONSTRAINTS=Y.

Report message to a moderator

Previous Topic: Importing Constraints...
Next Topic: downloading stored procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 01:37:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.