Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Proper way to use exp
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