Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: quite export script

Re: quite export script

From: Paul Drake <bdbafh_at_gmail.com>
Date: Tue, 5 Oct 2004 17:58:07 -0400
Message-ID: <910046b404100514581abb869d@mail.gmail.com>


Brian,

You need to put the instance into restricted session before you start the export executable, so its basically the same as you would for unix.
I'd recommend shutting down the instance (immediate)and startup restrict. Provided that the user account that you are exporting as has the DBA role granted to it (or something similar) which has the sys_priv "restricted session" granted to it, it will work.

Careful if others have been either directly granted the "restricted session" sys_priv or a role that has that privilege granted to it. Stopping the listeners or pulling the cat5 cable are more reliable methods. >:|

Paul

On Tue, 5 Oct 2004 13:48:24 -0600, Bryan Wells <bunjibry_at_gmail.com> wrote:
> does anyone have a script for exporting in restricted mode on w2k?
> ive been a unix for over a year, and Im out of touch with dos
>
> --
> Bryan Wells
> bunjibry_at_gmail.com
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 05 2004 - 16:53:43 CDT

Original text of this message

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