Re: Import a dmp file
Date: Wed, 23 Jan 2008 13:00:53 -0800 (PST)
On Jan 23, 2:23 pm, Curious Joe <joebob.john..._at_gmail.com> wrote:
> 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.
> 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/
> 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
> Export: Release 220.127.116.11.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 18.104.22.168.0 -
> With the Partitioning option
> JServer Release 22.214.171.124.0 - Production
> Export done in WE8ISO8859P15 character set and UTF8 NCHAR character
> About to export specified tables via Direct Path ...
> Current user changed to SYSADM
> . . exporting table PS_C_PYMNT_TBL_HST 1061407 rows
> Export terminated successfully without warnings.
> Hopefully this will help you help me!
> Thank you,
> 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- Hide quoted text -
> - Show quoted text -
Somewhat. Again, you'll need to create the SYSADM user (possibly there is a script to do so available from the source of this .dmp file). You can extract the CREATE TABLE/CREATE INDEX commands from your .dmp file:
imp user/pass_at_db file=<dmp filename here> full=y indexfile=my_word_this_is_complicated.sql
and then look into my_word_this_is_complicated.sql with a text editor and see where it's trying to put this table. You could also create the table into an existing tablespace by some judicious editing of the CREATE TABLE command [the CREATE TABLE commands are commented out in the indexfile created].
There is a lot you could do with this .dmp file, and any number of ways to get this table into a database. More than likely you'll need to find someone local who knows something about Oracle to help you inperson.
It's difficult to help you when I can't look over your shoulder and see what's happening.
David Fitzjarrell Received on Wed Jan 23 2008 - 15:00:53 CST