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

[Stephen Hoffman]

On 2015-05-13 15:37:15 +0000, Jan-Erik Soderholm said:

> Stephen Hoffman skrev den 2015-05-13 14:58:
>> 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>
>> 
>> 
> 
> TRUNCATE <table> is faster then DELETE FROM <table>, but you need
> more privs and a more "exclusive" access to the table.
> 
> If the table is not very large (whatever size that is) you
> can also try with DELETE FROM <table>.
> 
> Note also the other differences as described in "Oracle Rdb
> SQL Reference Manual Volume 4".
> 
> Jan-Erik.


-- 
Pure Personal Opinion | HoffmanLabs LLC