Oracle tables can be locked exclusively by using "lock table ... in exclusive mode". This is sometimes used e.g. in SAP BW systems. The lock is released when the next COMMIT or ROLLBACK takes place.
I have customized tables in my Dev. system.and they are not usefull now.So I want to lock those(Yes as you are saying it is not necesssary,but I just I want to knw).
The only possibility I see is to mark the table as read only on database level or to revoke the connecting user the permission to write data to that table.
However, that procedure is not common and one should rather use permissions in the SAP system to handle such things.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.