PL/SQL Code For Dropping All Objects in Schema   DECLARE v_itemcount INTEGER; BEGIN SELECT Count(*) INTO   v_itemcount FROM   all_objects AO WHERE  AO.owner = USER AND AO.object_type NOT IN ( ‘INDEX’ ) AND AO.object_name NOT LIKE ‘BIN$%’; WHILE ( v_itemcount > 0 ) LOOP FOR v_cmd IN (SELECT ‘drop ‘ || AO.object_type || ‘ ‘ || AO.object_name || Decode(AO.object_type, ‘TABLE’, ‘ CASCADE CONSTRAINTS’, ”) AS DROPCMD FROM   all_objects AO WHERE  AO.owner = USER AND AO.object_type NOT IN ( ‘INDEX’ ) AND AO.object_name NOT LIKE ‘BIN$%’) LOOP …

ERROR

Rac Voting Disk The Voting Disk File is a file on the shared cluster system or a shared raw device file. Voting disk a key component of clusterware and its …

To check Retention Guarantee for Undo Tablespace

ERROR Checking for existence of the ACL …. DECLARE * ERROR at line 1:

PL/SQL Code for Counting Rows In Schema Tables   DECLARE i INTEGER; BEGIN dbms_output.Put_line(‘Table Name,Row Count,’ || To_char(SYSDATE, ‘DD-MON-YYYY HH24:MI:SS’)); FOR v_table IN (SELECT ut.table_name FROM   user_tables ut) LOOP EXECUTE IMMEDIATE ‘select count(*) from ‘|| v_table.table_name INTO i; dbms_output.Put_line(v_table.table_name || ‘,’ || To_char(i)); END LOOP; END;    

Basic RAC Management Commands   Cluster Related Commands crs_stat -t Shows HA resource status (hard to read) crsstat Ouptut of crs_stat -t formatted nicely ps -ef|grep d.bin crsd.bin evmd.bin ocssd.bin …

CRS Administration   CRS Administration starting ## Starting CRS using Oracle 10g R1 not possible ## Starting CRS using Oracle 10g R2 $ORA_CRS_HOME/bin/crsctl start crs stopping ## Stopping CRS using …

How To Add Redo Logfiles In Standby Database   Step 1. First, Check MEMBER present in Standby Database. SQL> select member from v$logfile; MEMBER ———————————- E:\STANDBYLOGS\REDO03.LOG E:\STANDBYLOGS\REDO02.LOG E:\STANDBYLOGS\REDO01.LOG   Step 2. …