Re: Import and open database

In addition to what MotoX has mentioned you can stop the listener so that no one else can connect remotely from Oracle clients.

So, do the followiong:-
1. Startup in RESTRICT mode.
2. Stop the listener ( if you have dedicated listener )

   for this database or this SID.

Hope this helps,
Manoj Jain

In article <908866915.1350.0.nnrp-10.c2de712e_at_news.demon.co.uk>,   "MotoX" <rat_at_tat.a-tat.com> wrote:
> Er, 'exclusive' is really a Parallel Server concept for instances. Do you
> mean 'restricted'? If so, that will only let people on the system who have
> that privilege, normally only DBA's - so no, it won't do what you want, I
> think...
>
> I can't really see how you can reconcile "how I could make sure people are
> not hitting the database" and "database has to be open while doing imports
> which also means people can access it"?... If you don't want anyone on it,
> use a restricted startup.
>
> MotoX
>
> Vijay Ganesh Hariharan wrote in message ...
> >hi all,
> >
> >Want to know how I could make sure people are not hitting the database I am
> importing to. The database has to be open while doing
> >imports which also means people can access it. Will exclusive mode startup
> work?
> >
> >Thanks.
> >Vijay G Hariharan
> >vharih1_at_umbc.edu
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 11:07:27 CDT