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

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

T.J. replies:

> I vaguely remember some bugs in an unpatched install of that
> stopped me dead in my tracks, but patches were available at the time. My
> test database is running patch 6 (Windows x64), and
> DBMS_REDEFINITION works fine on tables with triggers for me.

I'll be confirming my patch levels before testing...

> Another gotcha that I just remembered though is foreign keys - if you move a
> parent table, the children will need to be manually repointed to the new
> (redefined) table. Really, you'll just want to watch for invalid objects

No worries for me there. No FKs, just PKs. And only a few triggers that I could disable temporarily off-hours. No PL/SQL to speak of, either, other than DBA stuff.



Received on Fri Feb 01 2013 - 20:50:47 CET

Original text of this message