Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: IMPORT

RE: IMPORT

From: <crcbedoy_at_proteccion.com.co>
Date: Fri, 8 Sep 2006 14:02:59 -0500
Message-ID: <OF175DCD45.12CA0D27-ON052571E3.00687542-052571E3.0067DD1C@proteccion.com.co>


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_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
Received on Fri Sep 08 2006 - 14:02:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US