Biju

www.bijoos.com

OracleDB12c New Feature: Added Administrative Privileges

by

Oracle11g Grid Infrastructure introduced SYSASM administrative privilege, in 12c we have 3 more administrative privileges… SYSBACKUP, SYSDG, SYSKM. SYSDBA, SYSOPER and SYSASM privileges and behavior are similar to 11gR2 in 12c database as well. SYSBACKUP administrative privilege has ability to perform RMAN backup and recovery operations, database startup and shutdown. This administrative user connects to … Read more

OracleDB12c New Feature: Adding, Dropping, Truncating Multiple Partitions

by

Yesterday, we discussed merging and splitting multiple partitions. The same feature is extended in 12c to add, drop or truncate multiple partitions in a single SQL statement. Add multiple partitions example: ALTER TABLE SALESDATA ADD PARTITION S2015Q1 VALUES LESS THAN (TO_DATE(’01-APR-15′,’DD-MON-YY’)), PARTITION S2015Q2 VALUES LESS THAN (TO_DATE(’01-JUL-15′,’DD-MON-YY’)), PARTITION S2015Q3 VALUES LESS THAN (TO_DATE(’01-OCT-15′,’DD-MON-YY’)), PARTITION S2015Q4 … Read more