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