Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: IMPORT

RE: IMPORT

From: Sweetser, Joe <Joe.Sweetser_at_infocrossing.com>
Date: Fri, 8 Sep 2006 12:07:18 -0700
Message-ID: <5CF4A34EE1FEA144B7474DC97E2F73A9FFB8EF@MAPI.iconnection.com>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of crcbedoy_at_proteccion.com.co
Sent: Friday, September 08, 2006 12:57 PM To: Thomas.Mercadante_at_labor.state.ny.us
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org 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.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 08 2006 - 14:07:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US