TO CHECK THE HIGH WATER MARK LEVEL OF TABLES set verify off col table_name for a20; column owner format a10 column alcblks heading ‘Allocated|Blocks’ just c column usdblks heading ‘Used|Blocks’…
Read MorePosted by : Saravanan Introduction This Post demonstrates about error ORA-01741 : illegal zero-length identifier Scenario While adding multiple schemas to a single workspace, we get the following error in…
Read MorePosted by : Mahe This Post describes about Installing various Database Components col COMP_ID for a20 col VERSION for a15 col STATUS for a10 col COMP_NAME for a40 select COMP_ID,…
Read MorePosted by : Pushparaj This Post describes about converting into RAC instance Add separate Undo Tablespaces First, Create 2 UNDO tablespaces for the 2 instances.PLINKTST1 > create undo tablespace UNDOTBS1…
Read MorePosted by : Narasimha Rao.K This Post demonstrates about Oracle Database and Applications Security Audit Part 1 Hello Everyone , I would like to start series of write ups/post…
Read MorePosted by : Mahe This Post demonstrates how to Renaming a constraints Renaming a constraints SQL> show user; USER is “MAHE” SQL> select dbms_metadata.get_ddl(‘TABLE’, ‘T1’) from dual; DBMS_METADATA.GET_DDL(‘TABLE’,’T1′) ———————————————————…
Read MorePosted by : Unknown Introduction This Post demonstrates about the Block change tracking for faster Incremental RMAN backups Block Change Tracking The details of changes in the blocks…
Read MorePosted by : Mahe Introduction This Post demonstrates about the Solaris EM12c Agent Unreachable with Error “peer not authenticated” Issue : ./emctl status agent Oracle Enterprise Manager Cloud Control 12c Release…
Read MorePosted by : Saravanan Introduction This Post demonstrates about ORA-10873 , the file 1 needs to be either taken out of backup mode or media recovered Scenario : Database went…
Read MorePosted by : Sundaravel Ramasubbu Introduction This Post demonstrates about Adpreclone.pl fails with RC-50007: Could not create cloning stage area Issue : adpreclone.pl fails with RC-50007: Could not create cloning…
Read More