[Info-vax] truncate of table is failing in oracle rdb

Stephen Hoffman seaohveh at hoffmanlabs.invalid
Wed May 13 08:58:16 EDT 2015


On 2015-05-13 03:10:31 +0000, Durga Prasad said:

> iam using openvms oracle rdb..
> ...
> SQL> truncate table transmars;
> %RDB-E-LOCK_CONFLICT, request failed due to locked resource
> -RDB-E-NO_META_UPDATE, metadata update failed

Some other process else likely has a conflicting lock; some row is 
likely actively accessed elsewhere.  You can wait, or you can cancel 
the conflicting activity.

Given that TRUNCATE TABLE is usually a DROP TABLE followed by a CREATE 
TABLE, see DROP TABLE 
<http://starlet.deltatel.ru/rdb$doc/oraclerdb/sqlrm7/sql_pro_131.html> 
for some details.

RMU has a way to view lock activity.  
<http://www.openvms.ru/rdb$doc/oraclerdb/rmurm7/rmu_ref_pro_showlocks.html> 



-- 
Pure Personal Opinion | HoffmanLabs LLC




More information about the Info-vax mailing list