| Subject | Help. Need to add a foreign key, but "object is in use" error in single-user mode. |
|---|---|
| Author | Andrew Guts |
| Post date | 2002-10-05T09:27:36Z |
Hello, IB support.
1. Database shutdown
2. Connect as SYSDBA
3. alter table tab2 add Field5 smallint references Table1 (Field1)
--- Unsuccessful metadata update object TABLE1 is in use -----
4. Verify the connections: one user connected (me)
What is wrong? Help me please.
Thanks ahead
Andrew
1. Database shutdown
2. Connect as SYSDBA
3. alter table tab2 add Field5 smallint references Table1 (Field1)
--- Unsuccessful metadata update object TABLE1 is in use -----
4. Verify the connections: one user connected (me)
What is wrong? Help me please.
Thanks ahead
Andrew