Re: Newbie Question - What to use to open dump file?

From: <fitzjarrell_at_cox.net>
Date: Tue, 19 Aug 2008 11:57:43 -0700 (PDT)
Message-ID: <0110ec73-5e7f-4f66-a841-3544c3c354a9@c58g2000hsc.googlegroups.com>


On Aug 19, 1:55 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> On Aug 19, 11:44 am, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
> > On Aug 19, 7:33 am, jfal..._at_socket.net wrote:
>
> > > On Aug 18, 10:46 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
> > > > On Aug 18, 10:40 am, jfal..._at_socket.net wrote:
>
> > > > > I have a customer that wanted me to look at some of their data.  They
> > > > > gave me a dump file from there oracle database.  I don't have an
> > > > > oracle system.  I was wondering if there is a standalone method of
> > > > > using this data similar to MSDE type of MSSQL or the Sybase
> > > > > SQLAnywhere single user software.  I don't mind spending some money on
> > > > > a 1 user version of software, but I don't want to put in an entire
> > > > > system for what may be a 1 time thing.  I downloaded a mobile lite
> > > > > install, but if I understand the docs, it is the app server and client
> > > > > tier of a three tier system.  What tool would you recommend?  Thanks
> > > > > for your help.
>
> > > > Any of the releases of Oracle would be free for such use, as far as I
> > > > know.  However, to make a smaller 'footprint' on your system  you
> > > > might look into Oracle XE.  Of course any of these are available atwww.oracle.comonthe'Downloads'page.
>
> > > > David Fitzjarrell
>
> > > I'm getting a message that says:
> > > Not Compatible
> > > Your export file is not supported.
> > > When I run the import script. from the Oracle front end.  It runs for
> > > a couple minutes and then this message pops up.  the version I have is
> > > XE 10g and opening the dmp with a text editor says EXPORT:V09.09.00
> > > so it was created with a lower version I think?  I am not sure of the
> > > layout of the tables and what not so I don't know where to go from
> > > here.  Any thoughts?
>
> > > On a side note, playing with the sample hr db that comes with the XE
> > > version is pretty slick.  I can see why people use oracle.
>
> > I'm not sure because I don't have time to check just now, but there
> > are new and old versions of import in 10g.  You need to use the old
> > version.  Go into a dos command window and type imp system/
> > yoursystempassword file=yourfilename log=yourfilename ignore=y and see
> > if that doesn't work better.  (Taking a very brief look at the XE
> > help, I'm wondering if it is expecting some sql file and calling it
> > import, which would be a third way).  Please be sure and give exactly
> > what you did so we can figure out issues like this, and be real
> > explicity (cut-and-paste if possible) with error messages.
>
> > jg
> > --
> > @home.com is bogus.http://imgs.xkcd.com/store/imgs/science_square_4.jpg-Hide quoted text -
>
> > - Show quoted text -
>
> Excellent catch, Joel, as I forgot about the possibility of trying to
> use expdp against a 'standard' exp-generated .dmp file.  You must use,
> as Joel pointed out, the exp utility, not expdp, to import the file
> into your database:
>
> $ exp file=.... [other parameters here]
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Whoops! That should be 'imp, not impdp', as none of the exp-named utilities import anything:

$imp file=.... [other options here]

I had exp on the brain when I typed that response.

David Fitzjarrell Received on Tue Aug 19 2008 - 13:57:43 CDT

Original text of this message