Re: Import a dmp file
Date: Wed, 23 Jan 2008 12:23:41 -0800 (PST)
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.
# Create the pipefile
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
Export: Release 18.104.22.168.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 22.214.171.124.0 -
With the Partitioning option
JServer Release 126.96.36.199.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!
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