RE: IMPORT

  • From: crcbedoy@xxxxxxxxxxxxxxxxx
  • To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
  • Date: Fri, 8 Sep 2006 14:02:59 -0500

Here it is some of the export log:

bash-2.05$ more backfulldlloquyreq0609080901.log

Connected to: Oracle9i Release 9.2.0.5.0 - 64bit Production
JServer Release 9.2.0.5.0 - Production
Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user QUYREC
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user QUYREC
About to export QUYREC's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export QUYREC's tables via Conventional Path ...
. . exporting table          BKP_FT_DETALLEFORMATO         71 rows 
exported

etc..

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 


  • References:

Other related posts: