RE: How to coalesce an LMT TS to drop extra datafiles?
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Fri, 1 Feb 2013 13:07:49 -0600 (CST)
Message-ID: <6bdd3046731bd82895a19a836ef74f63.squirrel_at_society.servebeer.com>
Niall tries to scare me with:
Date: Fri, 1 Feb 2013 13:07:49 -0600 (CST)
Message-ID: <6bdd3046731bd82895a19a836ef74f63.squirrel_at_society.servebeer.com>
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!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 01 2013 - 20:07:49 CET