[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