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

> I vaguely remember some bugs in an unpatched install of 11.2.0.3 that
> stopped me dead in my tracks, but patches were available at the time. My
> test database is running 11.2.0.3 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.

Thanks!

Rich

--
http://www.freelists.org/webpage/oracle-l