Re: How to open a *.dmp

If I may, it sounds like you are treating an Oracle database with the same mentality as an Access database in that you can copy the database from one PC to the other just by copying a file and opening it with a double click. If this is your thinking then you really need to find some documentation and do some reading because you have a lot to learn.

On the other hand, if you have installed oracle, created yourself a database and understand how to shutdown and startup this database then you just may be able to import the DMP file you have.

Yes, older version of a DMP file can be read or IMPorted into a newer version of the database. You WILL! encounter errors in the process. You will need to be able to decipher the messages and know if they are bad or acceptable.

Good luck.

Kevin Gillins

"Nils Tekampe" <Nils.Tekampe_at_web.de> wrote in message news:am7o17$55d$07$1_at_news.t-online.com...
> Hello,
> first: thanks a lot for these answers.
> I see: I have to learn a lot about oracle.
>
> There is0 one (or two) last question(s):
> Is it possible to import a dump from an older version of oracle or has the
> version to be exactly the same????
> I'm asking because i only can download the newest versions of oracle out
of
> the internet.
>
> Are there other and perhaps more comfortable ways to transfer an oracle-DB
> from one PC to another???
>
>
> mfg
> nils
> "TurkBear" <john.greco_at_dot.state.mn.us> schrieb im Newsbeitrag
> news:q2neouodb9v9duomc77umoku339vmi671o_at_4ax.com...
> > The question is incomplete..The dmp file is an Oracle export so Oracle's
> Import utility will read and load it into your
> > Oracle database - IF your Oracle is the same version, has the same users
> and you can handle the errors caused by tables
> > already existing..
> > If any of the above are not the case, you need to get more info about
the
> version that created the dmp and what it contains(
> > you can get that by using command line options to the IMP command- see
the
> docs)
> >
> >
> >
> > "Nils Tekampe" <Nils.Tekampe_at_web.de> wrote:
> >
> > >Hello,
> > >i had my first contact to an oracle-database today and now i have a
> little
> > >(i hope) problem.
> > >
> > >A friend gave me copy of an oracle database. This copy consists out of
> just
> > >one file. It is called copy.dmp.
> > >
> > >Now i have the problem, not to know how to open this file. What version
> of
> > >oracle do i need to open this file?
> > >
> > >I hope this question ist not to easy for you :-)
> > >
> > >thanks a lot
> > >
> > >nils
> > >
> >
> >
> >
> > -----------== Posted via Newsfeed.Com - Uncensored Usenet News
> ==----------
> > http://www.newsfeed.com The #1 Newsgroup Service in the World!
> > -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> =-----
>
>
Received on Tue Sep 17 2002 - 19:01:07 CDT