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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 29 Jul 2002 13:51:08 +0100
Message-ID: <3d453a3c$0$236$ed9e5944@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 - 07:51:08 CDT

Original text of this message

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