Vadim Mikheev wrote:
>
> I need in help:
>
> let's say you have serialized transaction in one session...
> Now, some other user drops a table that was in data base when
> serialized transaction began but does it before this transaction
> read table (first time)...
>
> 1. Will RDBMS allow to drop table? (And so abort
> serialized transaction if it tries read dropped
> table)
> 2. Or DROP TABLE will be blocked waiting when
> serialized transaction commits/aborts ?
>
> Could someone test this in Oracle/Informix/Sybase ?
>
> Vadim
Oracle 8 will drop the table without waiting. The serializable session
will not see the table either before or after reading the table, i.e.
point 1.
David