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_at_labor.state.ny.us> Enviado por: oracle-l-bounce_at_freelists.org 08/09/2006 12:00
Por favor, responda a
Thomas.Mercadante_at_labor.state.ny.us

Para
<crcbedoy_at_proteccion.com.co>

cc
<oracle-l_at_freelists.org>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of crcbedoy_at_proteccion.com.co Sent: Friday, September 08, 2006 12:07 PM To: Freeman, Donald
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org; rjamya_at_gmail.com; Ron.Reidy_at_arraybiopharma.com 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_at_state.pa.us> 08/09/2006 10:52

Para
<crcbedoy_at_proteccion.com.co>, <rjamya_at_gmail.com>
cc
<oracle-l_at_freelists.org>, <oracle-l-bounce_at_freelists.org>,
<Ron.Reidy_at_arraybiopharma.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of crcbedoy_at_proteccion.com.co Sent: Friday, September 08, 2006 11:57 AM To: rjamya_at_gmail.com
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org; Ron.Reidy_at_arraybiopharma.com
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_at_gmail.com>
Enviado por: oracle-l-bounce_at_freelists.org 08/09/2006 10:43

Por favor, responda a
rjamya_at_gmail.com  

Para
crcbedoy_at_proteccion.com.co
cc
Ron.Reidy_at_arraybiopharma.com, oracle-l_at_freelists.org, oracle-l-bounce_at_freelists.org
Asunto
Re: IMPORT      

try using fromuser/touser option.

Raj

On 9/8/06, crcbedoy_at_proteccion.com.co < crcbedoy_at_proteccion.com.co> wrote:

The Oracle versions are the same, 10g

--
http://www.freelists.org/webpage/oracle-l