Re: DDL & long-running query

On Tue, 10 May 2005 20:26:39 -0700, steven wrote:

> Hi John,
> Maybe sometimes query fail,maybe ddl have to wait.I think it's depend
> on what type of ddl.
> Here is a test case:
> SQL> select count(*) from t; - full table scan big table t
>
> On another session
> SQL>remove t to t_temp;
> table renamed.
>
> You can do many tests.
>
> Thanks.
>
> Steven
> a new DBA

That is not changing the structure of the table. Try dropping column of the table or adding a column to it.

-- 
Demagogue: One who preaches a doctrine he knows to be untrue to 
           men he knows to be idiots. 
H.L. Mencken