Re: Import a dmp file

This is not great news. I have the .sh and the .log from the export. I cannot find any import logs but I don't even know where to look for them. I just searched my drives and didn't see any.

.sh
#!/usr/bin/ksh

export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 export ORACLE_SID=fop1
export ORAENV_ASK=NO
. /usr/local/bin/oraenv

# Create the pipefile
mkfifo /export/fop/history/
exp_fop_PS_C_PYMNT_TBL_HST_061105_210005.pipe cat /export/fop/history/exp_fop_PS_C_PYMNT_TBL_HST_061105_210005.pipe | /usr/bin/gzip | split -b 2000m - /export/fop/history/ exp_fop_PS_C_PYMNT_TBL_HST_061105_210005.dmp.gz. &

exp / file=/export/fop/history/
exp_fop_PS_C_PYMNT_TBL_HST_061105_210005.pipe recordlength=65535 direct=y compress=n rows=Y consistent=y
tables=SYSADM.PS_C_PYMNT_TBL_HST >> /export/fop/history/ exp_fop_PS_C_PYMNT_TBL_HST_061105_210005.log 2>&1

rm /export/fop/history/exp_fop_PS_C_PYMNT_TBL_HST_061105_210005.pipe

.log

Export: Release 9.2.0.3.0 - Production on Sun Nov 5 21:25:52 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning option
JServer Release 9.2.0.3.0 - Production
Export done in WE8ISO8859P15 character set and UTF8 NCHAR character set

About to export specified tables via Direct Path ... Current user changed to SYSADM
. . exporting table PS_C_PYMNT_TBL_HST 1061407 rows exported
Export terminated successfully without warnings.

Hopefully this will help you help me!

Thank you,

CJ

On Jan 23, 12:37 pm, Markus Tazl <m_t..._at_yahoo.de> wrote:
> On 23 Jan., 20:17, Curious Joe <joebob.john..._at_gmail.com> wrote:
>
>
>
> > I am less than a novice on Oracle so I am sorry for such a simple
> > post.
>
> > A client has given me dmp files of their data. I have installed
> > Oracle 11g to import the dmp files so I can then transfer them to my
> > systems.
>
> > I am able to log in to sqlplus etc and the IMP command works except
> > that I am getting an error:
>
> > "ALTER SESSION SET CURRENT_SCHEMA= "SYSADM""
> > IMP-00003: ORACLE error 1435 encountered
> > ORA-01435: user does not exist
> > IMP-00000: Import terminated unsuccessfully
>
> > Can anyone help me with this? I can "list" the contents etc if
> > neede
>
> I'm afraid there might be several reasons ;-( As David said, missing
> tablespaces (beside other reasons)
> might cause some trouble ...
>
> Maybe you could post the content of your import.log ? Chances are that
> this might help to find a way to
> solve your problem ...
>
> best regards,
> Markus Tazl
>
> --
> Markus Tazl
Received on Wed Jan 23 2008 - 14:23:41 CST