RE: IMPORT
- From: crcbedoy@xxxxxxxxxxxxxxxxx
- To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
- Date: Fri, 8 Sep 2006 13:57:05 -0500
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:
