RE: IMPORT

  • From: "Sweetser, Joe" <Joe.Sweetser@xxxxxxxxxxxxxxxx>
  • To: <crcbedoy@xxxxxxxxxxxxxxxxx>, <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • Date: Fri, 8 Sep 2006 12:07:18 -0700

I would try:

 

    imp user/pass full=y show=y
file=/app5/oracle/backup/prt9dllo/quyrec.dmp

 

to see what's in the export file.  It might give you a clue as to the
user mismatch/nonmatch.

 

-joe

http://www.peaceaday.com

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Friday, September 08, 2006 12:57 PM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
Subject: RE: IMPORT

 


bash-2.05$ imp myusername/mypassword IGNORE=y FROMUSER=QUYREC
TOUSER=QUYREC FILE=/app5/oracle/backup/prt9dllo/quyrec.dmp 

Import: Release 10.2.0.2.0 - Production on Fri Sep 8 13:36:05 2006 

Copyright (c) 1982, 2005, Oracle.  All rights reserved. 





Other related posts: