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.


Connected to: Oracle Database 10g Release 10.2.0.2.0 - 64bit Production
With the Real Application Clusters option

Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by RESPALDOS, not by you

import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character 
set
export server uses UTF8 NCHAR character set (possible ncharset conversion)
IMP-00046: using FILESIZE value from export file of 2097152000

IMP-00034: Warning: FromUser "QUYREC" not found in export file
Import terminated successfully with warnings.


I changed the environment settings, I created the user in the new SID with 
the tablespaces and all the grants, I even tried running the "imp" 
directly from the Oracle 10g's "bin" folder, and nothing works:(, I keep 
getting this error.



Isabel Bedoya GÃmez
Centro de GestiÃn y Control
Tel. 2307500 ext:



"Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx> 
Enviado por: oracle-l-bounce@xxxxxxxxxxxxx
08/09/2006 12:00
Por favor, responda a
Thomas.Mercadante@xxxxxxxxxxxxxxxxx


Para
<crcbedoy@xxxxxxxxxxxxxxxxx>
cc
<oracle-l@xxxxxxxxxxxxx>
Asunto
RE: IMPORT






I know that you canât use âFULLâ and âFROMUSER/TOUSERâ in the same 
import 
statement.
 
Can you show us the error you are getting?
 

This transmission may contain confidential, proprietary, or privileged 
information which is intended solely for use by the individual or entity 
to whom it is addressed.  If you are not the intended recipient, you are 
hereby notified that any disclosure, dissemination, copying or 
distribution of this transmission or its attachments is strictly 
prohibited.  In addition, unauthorized access to this transmission may 
violate federal or State law, including the Electronic Communications 
Privacy Act of 1985.  If you have received this transmission in error, 
please notify the sender immediately by return e-mail and delete the 
transmission and its attachments. 


From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
On Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Friday, September 08, 2006 12:07 PM
To: Freeman, Donald
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx; 
rjamya@xxxxxxxxx; Ron.Reidy@xxxxxxxxxxxxxxxxxx
Subject: RE: IMPORT
 

imp myusername/mypassword FULL=y IGNORE=y FROMUSER=QUYREC TOUSER=QUYREC 
FILE=/app5/oracle/backup/prt9dllo/quyrec.dmp 

Isabel Bedoya GÃmez
Centro de GestiÃn y Control
Tel. 2307500 ext: 


"Freeman, Donald" <dofreeman@xxxxxxxxxxx> 
08/09/2006 10:52 


Para
<crcbedoy@xxxxxxxxxxxxxxxxx>, <rjamya@xxxxxxxxx> 
cc
<oracle-l@xxxxxxxxxxxxx>, <oracle-l-bounce@xxxxxxxxxxxxx>, 
<Ron.Reidy@xxxxxxxxxxxxxxxxxx> 
Asunto
RE: IMPORT
 


 
 




Can you post your command line, your parameter file contents, and the 
contents of your import log file?   Did you check your export log file to 
make sure that what you want is actually in there? 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 
On Behalf Of crcbedoy@xxxxxxxxxxxxxxxxx
Sent: Friday, September 08, 2006 11:57 AM
To: rjamya@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx; 
Ron.Reidy@xxxxxxxxxxxxxxxxxx
Subject: Re: IMPORT


I did it and nothing:(, still I can't see any object under the user's 
schema 

Isabel Bedoya GÃmez
Centro de GestiÃn y Control
Tel. 2307500 ext: 

rjamya <rjamya@xxxxxxxxx> 
Enviado por: oracle-l-bounce@xxxxxxxxxxxxx 
08/09/2006 10:43 


Por favor, responda a
rjamya@xxxxxxxxx

 


Para
crcbedoy@xxxxxxxxxxxxxxxxx 
cc
Ron.Reidy@xxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx, 
oracle-l-bounce@xxxxxxxxxxxxx 
Asunto
Re: IMPORT
 


 
 





try using fromuser/touser option.

Raj

On 9/8/06, crcbedoy@xxxxxxxxxxxxxxxxx < crcbedoy@xxxxxxxxxxxxxxxxx> wrote: 


The Oracle versions are the same, 10g

Other related posts: