Oracle 12c Top 20 New
Features for DevelopersArup Nanda
Longtime Oracle DBAAgenda
• Top features of Oracle 12c for Developers
• Excludes PL/SQL– Covered in a different session
• Of interest to developers and users– Not to DBAsOracle12c Top 20 New Features for Developers
2Online DDL
• DDLs do not need lock.
• DML continues as usual– drop index i1 online
– alter index i1 unusable online
– alter table t1 set unused columns online
– alter table t1 drop column c1 online
– alter table t1 move partit
