[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