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

Durga Prasad durga.gdp at gmail.com
Tue May 12 23:10:31 EDT 2015


iam using openvms oracle rdb.. 

while truncate a table igot this error..

i found i am missing some thing. 

it will highly appreciated if anybody help this issue

SQL> roll;
%SQL-F-NO_TXNOUT, No transaction outstanding
SQL> SET TRANSACTION READ WRITE;
SQL> truncate table transmars;
%RDB-E-LOCK_CONFLICT, request failed due to locked resource
-RDB-E-NO_META_UPDATE, metadata update failed
-RDMS-F-TIMEOUT, timeout on client '........TRAN' 4E415254000000920000000400000055
-COSI-W-CANCEL, operation canceled
SQL> roll;
SQL> set trans nowait;
SQL> truncate table transmars;
%RDB-E-LOCK_CONFLICT, request failed due to locked resource
-RDB-E-NO_META_UPDATE, metadata update failed





More information about the Info-vax mailing list