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

Home -> Community -> Usenet -> c.d.o.server -> Re: Proper way to use exp

Re: Proper way to use exp

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 29 Jul 2002 23:17:07 +1000
Message-ID: <%7b19.46862$Hj3.142601@newsfeeds.bigpond.com>


Hi Niall,

And my initial thought.

But what about reopening the database in read only ?

Regards

Richard
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3d453a3c$0$236$ed9e5944_at_reading.news.pipex.net...
> Seems like an excellent approach to me.
>
> The 'correct' approach would be to shut the database down (to kick
everyone
> off) and then issue startup restrict so that only you can connect.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "John" <jriker1_at_yahoo.com> wrote in message
> news:e6bb5a8d.0207290443.65c23c02_at_posting.google.com...
> > I'm going to export an Oracle 8.0.5 database for the last time to be
> > imported into a new Oracle 8.1.7 system. Can someone tell me what the
> > proper steps are to do a full export, without allowing any changes to
> > the system? Not sure if pulling the network plug and doing a full
> > export with consistant=y is the right answer or not. (:
> >
> > Thanks.
> >
> > JR
>
>
Received on Mon Jul 29 2002 - 08:17:07 CDT

Original text of this message

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