Just specify consistent=y and there will be no problem. RBG
----- Original Message -----
From: "Zhou, Tapiwanashe" <tzhou_at_border.co.zw>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, December 19, 2000 1:00 AM
Subject: RE: Starting and stopping listener -fears??
> Are there no implications to consistency of data if people update the
> database during export?
>
> -----Original Message-----
> Kostyszyn
> Sent: Monday, December 18, 2000 6:36 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If you're just doing exports why would you want to disconnect the users?
> Kev
>
> -----Original Message-----
> Tapiwanashe
> Sent: Monday, December 18, 2000 9:25 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hie list,
>
> I use export for my back ups. I want to prevent users from connecting to
> Oracle while backup is proceeding. I have in mind "stopping Oracle
listener"
> before backup and "starting it" afterwards using
> lsnrctrl stop and lsnrctrl start.
> Now my fears are, since some users may be actively connected, if I use
this
> won't listener crush (sic) and fail to re-start.
>
> Thanks in advance.
>
> Tapiwa
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Zhou, Tapiwanashe
> INET: tzhou_at_border.co.zw
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
> INET: kevin_at_dulcian.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Zhou, Tapiwanashe
> INET: tzhou_at_border.co.zw
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Dec 19 2000 - 09:52:33 CST
