Subject Re: Unsuccessful metadata update
--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:
> At 12:01 PM 7/26/2001 +0200, Bernhard Döbler wrote:
> Creating a foreign key requires exclusive access to the database -
> I think that's all that message is saying. Chase everybody off,
> connect, and execute that statement before doing anything else.


that's why I logged in as SYSDBA. As this user I can shut the DB down
to singleuser mode. But I don't want to create the tables as SYSDBA.
How else to make sure there's noone using the DB than me as standard
user? Create the tables as regular user, login as SYSDBA to create
FOREIGN KEYs, log out and in again as simple user and do the other

Best Regards