RE: How to coalesce an LMT TS to drop extra datafiles?

From: Rich Jesse <>
Date: Fri, 1 Feb 2013 13:07:49 -0600 (CST)
Message-ID: <>

Niall tries to scare me with:

> We've run into a horrible bug with dbms_redefinition on 11.2 where a
> trigger owned by sys for pl/sql scope breaks a unique constraint also owned
> by sys and terminates the redefining session halfway through with a 604
> IIRC we then got the same error inserting into any table with a trigger on
> it. This may have applied only where the table being redefined had a
> trigger on it.

Putting that tidbit in my wiki now...

Thanks for the heads-up!


Received on Fri Feb 01 2013 - 20:07:49 CET

Original text of this message