First time here? Check out the FAQ!
x

Oracle RDB storage area/storage map maintenance.

0 votes
asked by (120 points) about Oracle Rdb Developer Tools for Visual Studio
edited by

How to resize storage area because my table is very big now and table is without index.
While doing:

  • truncate
  • drop/create storage area
  • dorp/create storage map

I found the error:

SQL> truncate table xxxxxxxx;
%RDB-E-LOCKCONFLICT, 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

I need help while using truncation, drop/adding storage area, drop/adding storage map.

1 Answer

0 votes
answered by (264k points)

When you encounter the following message: "%RDB-E-LOCK_CONFLICT, request failed due to locked resource", it means that the table is currently used by another use. You need to use the CANCEL on the FSEDIT and then repeat the procedure.

Use Google Search for additional information: https://goo.gl/bBkmZz

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...