8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Online Move of Partitions and Sub-Partitions in Oracle 12c Release 1

Sydoracle said...

To add to the restrictions, you can't do an ONLINE move or UPDATE INDEXES against a Materialized View either, at least in 12.2.
I know they aren't really tables, but they have physical data and index plus they show up in the USER_TABLES view.

Tim... said...


I've added that. Thanks for the heads-up. :)



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.