Right now, I am reading the Expert ORACLE from Thomas Kyte.. Its very interesting book.
In the chapter for Locking, I have found method, which will not allow droping and modifying the structure of a your table.
Its just a:
alter table table_name disable table lock;
In the chapter for Locking, I have found method, which will not allow droping and modifying the structure of a your table.
Its just a:
alter table table_name disable table lock;
Now, you just need to alter the table and disable locking.
And nobody will be able to drop or modify the table structure until you enable locking on the table again.