Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to refresh the complete database using the export dump?.

Re: How to refresh the complete database using the export dump?.

From: Dan Norris <dannorris_at_dannorris.com>
Date: Sun, 15 Jul 2007 08:15:56 -0700 (PDT)
Message-ID: <903837.13986.qm@web35406.mail.mud.yahoo.com>


Ahhh...the beauty of the written word--so many ways to (mis)interpret the intention of a few words.

My advice: In cases where there may be some "grey," always give the benefit of the doubt to the author.

It's situations like these that remind me why there's no substitute for face-to-face meetings.

Enjoy your Sunday (or whatever day it may be in your timezone).

Dan

Actually I thought Mark's reply spot on. Not just RTFM nor a straight answer because there's a good chance that exp is being used inappropriately. Rather a nudge in the right direction and an invite to think. That's mentoring in my book - though I may have been getting it wrong of course.

On 7/14/07, Bryan Wells <bunjibry_at_gmail.com> wrote:
> Hey Mark, I thought this forum was for learning/mentoring not har*ass*ing.
> I take this site very seriously as i am *always* learning and needing to
> learn. I have been a DBA by title for about 3years, and i consider myself a
> newbie, as im sure others on this forum might. i believe your comments
> could have been left at "Try the Utilities manual". Take it easy. you were
> new once!
>
> On 7/13/07, Mark Brinsmead <pythianbrinsmead_at_gmail.com> wrote:
> >
> > Well, since nobody else has said it, I suppose I might as well...
> >
> > RTFM.
> >
> > Try the "Utilities" manual, which covers Export/Import quite thoroughly.
> >
> > In the meantime, I'll give you a hint... Your solution will probably
> > include:
> > imp FULL=Y FILE=my_export.dmp ...
> >
> >
> > By the way, if you don't know how to "restore" them, you may want to ask
> > yourself why you are making exports to begin with. There is an excellent
> > chance that they do not do what you think they do...
> >
> >
> > On 7/10/07, Anant <shastry17_at_gmail.com> wrote:
> > >
> > > Hi all,
> > > Can you please suggest me how to import the whole database from the
> > > export dump?( I mean the whole database).
> > >
> > > Thanks in advance,
> > > Ann
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
> > >
> >
> >
> > --
> > Cheers,
> > -- Mark Brinsmead
> > Senior DBA,
> > The Pythian Group
> > http://www.pythian.com/blogs
>
>
>
>
> --
> Bryan S Wells
> Cell: 303.532.9879
> Email: bunjibry_at_gmail.com
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l







--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jul 15 2007 - 10:15:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US