• hi this is abhi ,

    simply write this sql query on your sql prompt:

    connect scott/tiger

    -- u must authorize as a sysdba:

    lock table table_name in share mode;

    u can also lock your table in exclusive mode.