If you delete most of the rows in one table, you probably want to regain that space, to minimize IO and fragmentation. If you delete most of the rows in most of the tables, you probably also want to resize the datafile to reduce storage and backup space. In this case, you could move your […]
Month: October 2016
OTN Appreciation Day : Partition your table online !
#ThanksOTN @oraclebase No, I am not talking about DBMS_REDEFINITION, where you get a kind of online feeling. No, I don’t want to rename my table, rename my foreign keys, my primary key, my not-null-constraints, recreate my referential integrity, recompile my triggers. I just want to partition a non-partitioned table. ALTER TABLE EMP MODIFY PARTITION BY […]
Enterprise Manager 13c R2 is out
#EM13R2 is out https://t.co/dIwIn0jxp9 — laurentsch (@laurentsch) October 6, 2016 Download it here : oracle.com/technetwork/oem/grid-control/downloads Documentation : docs.oracle.com/cd/E73210_01