RE: How to coalesce an LMT TS to drop extra datafiles?
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 1 Feb 2013 13:50:47 -0600 (CST)
T.J. replies:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
