Newbie Question - What to use to open dump file?
jfa...@socket.net
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.
ora...@msn.com
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 at
www.oracle.com on the 'Downloads' page.
David Fitzjarrell
gazzag
What version of Oracle?
Anyway, I second David Fitzjarrell's post. In addition to creating a
database, you'll need to look up how to use Oracle's import function
("imp" or "impdp", depending on your version) in the Utilities Guide
http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/toc.htm
HTH
-g
jfa...@socket.net
>
> 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.
gazzag
> 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.
This is why version information is so important. It would appear that
your client has used the export utility shipped with 9i.
You have two choices:
1. Get them to re-do the export with a 10g client.
2. Download Oracle 9i from http://www.oracle.com/technology/software/products/oracle9i/index.html
Incidentally, the HR "database" you reference is actually a _schema_
within your XE _database_ ;)
HTH
-g
ora...@msn.com
> On Aug 18, 10:46 am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
>
>
>
>
> > On Aug 18, 10:40 am, jfal...@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
>
> > 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
>
> - Show quoted text -
Questions, questions:
1) how was this .dmp file delivered to you?
2) opening this file with a text editor MAY have caused problems.
Can you obtain another copy?
Normally a .dmp created with the 9i exp tools will be 'importable'
into a 10g database without issue, even XE. I'm expecting that you
have a 'corrupted' file, most likely containing additional linefeed
characters from an ASCII transfer. Such files should be transferred
(via ftp) in binary mode.
David Fitzjarrell
joel garry
> On Aug 18, 10:46 am, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
>
>
>
>
> > On Aug 18, 10:40 am, jfal...@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
>
> > 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
ora...@msn.com
>
> - 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
ora...@msn.com
>
> > - 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]
>
>
> - 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
joel garry
> On Aug 19, 1:55 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
>
>
>
>
> > On Aug 19, 11:44 am, joel garry <joel-ga...@home.com> wrote:
>
> > > On Aug 19, 7:33 am, jfal...@socket.net wrote:
>
> > > 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-Hidequoted 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
I don't know what I had on the brain when I typed explicity, but it
kind of works!
To the OP: Some more general info about oracle and this group at
http://dbaoracle.net/readme-cdos.htm
jg
--
@home.com is bogus
http://www.dba-oracle.com/t_funny_job_interview_questions.htm
jfa...@socket.net
>
> - Show quoted text -
Well, I used this command with full=y as well. I basically kept doing
it and it would say some user didn't exist. I'd add them and in the
end it all imported. I did it first on 9i because the messages
bounced back were more specific. After I knew all the names, I added
them all at once to the 10i system and the the import woked there as
well. I will be off to get a book tomorrow as it looks like oacle
might be fun to learn a bit more about.
The one queston I had was whether there is a size limit to the 10i
express edition? The customer wants to send me a few huge dmp files
to look at. This one was 42 meg. so I guess the others are much
bigger. Thanks to all for your help!
sybr...@hccnet.nl
>The one queston I had was whether there is a size limit to the 10i
>express edition? The customer wants to send me a few huge dmp files
>to look at. This one was 42 meg. so I guess the others are much
>bigger. Thanks to all for your help!
The size limit is 4 G.
--
Sybrand Bakker
Senior Oracle DBA