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 ----- Original Message ---- From: Niall Litchfield <niall.litchfield@xxxxxxxxx> To: bunjibry@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx> Sent: Sunday, July 15, 2007 8:57:53 AM Subject: Re: How to refresh the complete database using the export dump?. 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@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx> 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 > > > -- > > > //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@xxxxxxxxx > -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l