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

[Jan-Erik Soderholm]

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.