Unable to drop RdB database

Thomson, Martyn EDUC:EX martyn.thomson at gov.bc.ca
Tue Jan 8 15:13:22 CST 2008


Hi Listers. Not exacly a PH question but related...
I am attempting to drop an Oracle RdB V7.2 database but can't -
SQL> drop database filename SLD.RDB;
%RDB-E-LOCK_CONFLICT, request failed due to locked resource
-RDMS-F-LCKCNFLCT, lock conflict on client 'DDL' 4C444400000055

$RMU/SHOW lists - 
   - 1 active database user on this node
      - 218C3B93:1 - SLDDRD036000B72, EDUC_SLW_SQS
        - attached  8-JAN-2008 12:49:31.43 (elapsed 0 00:00:02)
        - image $1$DGA1:[SYS1.SYSCOMMON.][SYSEXE]RDB$NATCONN72.EXE

If I try to close the database - 
$rmu/close/abort/network SLD_RDB_DATABASE

...this "user" immediately reconnects.

Can anyone tell me what this is and if it's safe to kill it - and how to kill it?
TIA,
Regards, Martyn



More information about the powerh-l mailing list