Oracle RDB storage area/storage map maintenance.

Question

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-NOMETA_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.

Answer 1

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