Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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?
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 <mailto:crcbedoy_at_proteccion.com.co> < crcbedoy_at_proteccion.com.co <mailto:crcbedoy_at_proteccion.com.co> > wrote:
The Oracle versions are the same, 10g
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 08 2006 - 12:00:43 CDT
![]() |
![]() |