In Oracle 12c Release 2, a new feature was added whereby we could convert a non-partitioned table to a partitioned table with a MODIFY clause added to the ALTER TABLE SQL statement. In addition, the operation could be performed online enabling concurrent DML operations while the conversion was being performed. This was a very good […]
In Oracle 12c Release 2, tablespaces can now be encrypted while they are online and in read-write mode. In earlier releases, the tablespace had to be taken offline first or the database had to be in the mount state and not open. In addition, now in 12.2 the SYSTEM, SYSAUX and UNDO tablespaces can also […]
Online Move Partition In Oracle 12c we can now move as well as compress partitions online while DML transactions on the partitioned table are in progress. In earlier versions we would get an error like the one shown below if we attempted to move a partition while a DML statement on the partitioned table was […]
