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 - 07:51:08 CDT
