|
||||
|
From 12c onwards, we can create a mixed indexes (bitmap and btree both) on same columns which is very useful in DW environments. Before to 12c you will receive the such column is already indexed error or index already exists if you want to create the same. I have a copy of dba_objects as […] 12c Introduced the datafiles movement online, Earlier to 12c we have to a) offline the datafile b) Move the datafile to new location using os command c) Rename the datafile for data dictionary update d) Online the datafile From 12c, its just need a command "alter database move datafile" Lets see how it works […] Few books released so far on 12c features or includes 12c Features, but all are not India (Asia) editions so they might be expensive, Watch out for this books in Flipkart and you may get for lesser prices once they get released here in India. 12c New Features book from Robert Freeman As usual […] If you are unable to read, click to download Diagram Source : Oracle.com (the document is uploaded for education purpose only not for any other commercial purpose) Click here to download
[…] Starting/Stopping CDB and PDBs The traditional approach of starting and stopping databases is now only valid for CDB. So in order to start and stop CDB you will use the familiar startup and shutdown commands. PDBs don’t get automatically started with CDB. Even if your CDB is up and running it is possible […] Create & Plug and Unplug PDB’s To Create PDB’s the following methods can be followed Copying From PDB Seed Cloning from a existing PDB using Locally Remotely through DB Link Plugging in Plugging in an unplugged DB (unplug and plug as database into same container database) Plugging in a NON-CDB as […] From 12c onwards, Oracle 12c introduced truncate with cascade so when truncate operates on master table the child table rows also get truncated automatically. SCOTT@PDB > create table MASTER ( 2 ID number generated always as identity PRIMARY KEY, 3 NAME VARCHAR2(20) 4 ); Table created. SCOTT@PDB > create table CHILD ( 2 ID […] RMAN backup scenarios in 12c, With the advent of 12c PDB/CDB rman backup has changed a lot while taking backups or restoration. Backups on PDB or CDB “BACKUP PLUGGABLE DATABASE” – To take backups for a pluggable database “BACKUP DATABASE” – “BACKUP DATABASE;” on root container backs up the whole container includes SEED Container […] From 12c onwards we have seperate roles to be created for OS Authentication Prior to 12c we have OSDBA, OSOPER, OSASM, OSDBA, OSOPER groups From 12c onwards, OSBACKUPDBA maps to backupdba by default and is used to allow users to backup the database. Users in this group can connect as SYSBACKUP and have their […] In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases. You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same. The […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!