Re: Import a dmp file

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.
>
> .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- 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