Re: quite export script

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