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: Mark Brinsmead <pythianbrinsmead_at_gmail.com>
Date: Fri, 13 Jul 2007 23:37:10 -0600
Message-ID: <cf3341710707132237h47be45f4qd8da59b7008208fd@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jul 14 2007 - 00:37:10 CDT

Original text of this message

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