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

On Aug 19, 11:57 am, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> 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:
>

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