Dear heLen,

I tried this. But this allows multiple SYSDBA
connections to be established with the 'shutdown' DB.
Is there a more reliable approach than this?

Thanks,
Suresh.K.V.

--- Helen Borrie <helebor@...> wrote: > At
02:32 PM 28/04/2004 +0100, you wrote:

>
> >I wish this could be done but my observation
> >contradicts this solution. Just having two
> connections
> >and performing create table with a foreign key
> >definition gives me the error. So, such a 'defer'
> DDL
> >approach will not work. One solution I can think of
> is
> >to create the tables up front rather than doing it
> >from my application. This way, I can ensure
> >"Exclusive" access to the DB (at least from my own
> >application) during the DDL execution. I can not
> still
> >avoid some user trying to connect using (say) a
> isql
> >console to the same DB !
>
> Of course you can. You perform a database shutdown
> (see gfix -shut) which
> gives you exclusive access until you bring the
> database online again with
> gfix -online.
>
> /heLen
>
>

____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html