Re: Proper way to use exp

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 29 Jul 2002 14:37:21 +0100
Message-ID: <3d454511$0$237$ed9e5944@reading.news.pipex.net>

Let people look at my data while I'm exporting it? never I tell you. !

OK maybe that's a reasonable alternative as well.

OR make sure you have large rollback segments don't bother with any of this and export with consistent=y then import. If people say 'but data that I put in the system is missing' you can say 'ah you put it in after the final export of the system so you will just have to re-enter all over again.' You can cackle insanely if the fancy takes you as well.

--
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

******************************************

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:%7b19.46862$Hj3.142601_at_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:37:21 CDT