For copying ALTER TABLE the server sets table lock TL_READ_NO_INSERT
on the originating table. Use that instead of increasing lock. Ensure
that we lock tuples exclusively for the copying scan table. Adding test
case that verifies there is no more lock conflict.

Approved by : Frazer Clement <frazer.clement@oracle.com>