Tuesday, July 20, 2010

Bulk Updation in Address: Move one column data to another

›
Declare cursor CUR_TAB is SELECT rowid,a.* FROM accountaddressdetail11 a WHERE CODE LIKE 'In%'; l_b number:=0; Begin for CUR_REC in ...

Bulk Updation: update EmailCC column

›
Declare cursor CUR_BULK_UPDATE is SELECT rowid,a.* FROM ACCOUNTEMAILDETAIL a WHERE CODE NOT LIKE '%M'; l_b number:=0; Begin for CURS...
Wednesday, July 14, 2010

Oracle 11g Standby Database

›
Oracle Standby database on same machine (for testing) -----------------I. Before you get started:------------------- 1. Make sure the operat...
Friday, June 25, 2010

Oracle Database Growth Report

›
select sum(space_used_delta) / 1024 / 1024 "Space used (M)", sum(c.bytes) / 1024 / 1024 "Total Schema Size (M)", round(s...

Database Growth Monitoring Script

›
Step : 1 Calculate total Size of tablespace select sum(bytes)/1024/1024 "TOTAL SIZE (MB)" from dba_Data_files Step : 2 Calculate F...
Thursday, June 24, 2010

Oracle User Login Lock Wrong Attempt details

›
select username,osuser,machine,blocking_session from v$session where username='LDBO'; select username,os_username,to_char(timestamp,...
Wednesday, June 9, 2010

Oracle Password Policy

›
-- This script sets the default password resource parameters -- This script needs to be run to enable the password features. -- However th...
Tuesday, June 8, 2010

Restore Database when source database(E:) and destination database location(D:) is different

›
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'D:\archive1011\sns1011\%F'; CONFIGURE CHANNEL DEVICE TYPE DISK FORM...

Oracle 10g 32 bit at Window 7 (64 bit)

›
go to this folder “E:\Installers\Oracle_10g_1023\Disk1\stage\prereq\db” locate the file “refhost.xml”, open it with notepad now add the foll...

meta tags format

›
=============================== no...

Oracle Standby Database / Diaster recovery Solution

›
-----------------I. Before you get started:------------------- 1. Make sure the operating system and platform architecture on the primary an...

Oracle RMAN Duplicate Database / Clone Database

›
Configure The Network We need to configure the network so that there is connectivity to the target (source) database and to the database we ...
Thursday, May 20, 2010

Oracle Export Backup Job Email Notification

›
---------------------------------------------Export.bat--------------------------- @ECHO off SETLOCAL IF [%1]==[] goto s_start ECH...

Oracler RMAN Job Email Notification

›
------------------------------------------------RMAN.bat-------------------- @ECHO off SETLOCAL IF [%1]==[] goto s_start ECHO GETDA...
Tuesday, April 20, 2010

Reuse statements, cursor_sharing=force

›
Reuse statements select * from emp where ename = :EMPNAME select * from v$parameter where name like '%cursor_sharing%'; cursor_shari...

Oracle Flushing-Pinning PL/SQL packages, FLUSH SHARED POOL

›
Oracle Flushing-Pinning PL/SQL packages, FLUSH SHARED POOL http://www.remote-dba.cc/oracle_tips_flushing_secrets.htm 1. Pinning all com...
Tuesday, April 13, 2010

RMAN Block Corruption Detection & Recovery

›
Block Media Recovery with RMAN sql>select file# block# from v$database_block_corruption; --corrupted block Rman>> block recover da...

RMAN recover & open database if archive log missing

›
RMAN recover and open the database if the archive log required for recovery is missing 1) Set _ALLOW_RESETLOGS_CORRUPTION=TRUE in init.ora f...

RMAN recovery from loss of all online redo log files

›
RMAN recovery from loss of all online redo log files SQL> select thread#,sequence#,status from v$Log; set oracle_sid=sns6 rman Target SYS...
Monday, April 12, 2010

Uninstall Oracle from Server Completely

›
Uninstall Oracle # Stop any Oracle services that have been left running. Start->Settings->Control Panel->Services Look for any serv...