Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: IMPORT
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-lReceived on Fri Sep 08 2006 - 14:02:59 CDT
![]() |
![]() |