Top 30 Oracle 19c feature quick look to make dba life easy

 #1 Dynamic fast_start_failover setting to allow changing standby database without need of stopping and starting the data guard broker. 


 #2 Observe-only mode to discover any failures anticipated during fail over without performing actual transition to available standby database. 


 #3 Propagate restore point to standby which was created in primary database to perform point in time recovery. This allows standby to be restored back to the same state as primary using restore point information kept in control file.


 #4 Standby db flashback when primary flashbacks which helps dba by avoiding overhead task of re-creating standby database.




ORA-12899: value too large for column due to 12c char to data length conversion setting



ORA- Error:


ORA-12899: value too large for column "NSM_USER"."NSM_DOC_TYPE_TAB"."DIVISION" (actual: 103, maximum: 100)

Cause :

Table was created with explicit CHAR mentioned in VARCHAR2 data type.
1 CHAR is 4 BYTES.  

create table NSM_DOC_TYPE_TAB (
STATUS varchar2(32 char),   
CMS_CODE       varchar2(10 char),     
DIVISION    varchar2(100 char),   
DEPT   varchar2(255 char)                    
);        

iPhone Vs Android ... Vote & Know More



The two most powerful mobile operating device around the world, Lets find out their comparison and Vote your favorite !