Friday, October 21, 2011

Data Pump EXPDP

›
expdp userid="'sys/oracle@ari1112srv as sysdba'" FULL=y directory=dpump_dir2 dumpfile=ari1112.DMP LOGFILE=ari1112.LOG expd...

Email Notification for System Event

›
Eventtriggers /Create /ru Administrator /rp afl07839 /TR "Event Triggers for unexptected shutdown" /EID "6008" /TK d:\Em...
Tuesday, September 20, 2011

Remove partition without delete data

›
1) ALTER TABLE FALEDDRCR MERGE PARTITIONS BR1000, BR1050 INTO PARTITION BR1050 tablespace USR; ALTER TABLE FALEDDRCR MERGE PA...
Thursday, August 25, 2011

Server Disk Space Notification

›
' Sample code for monitoring windows disk space ' Constants for drive types Const Unknown = 0 Const Removable = 1 Const Fi...

Low Disk Space Window Notification

›
Set wshShell = WScript.CreateObject( "WScript.Shell" ) strComputerName = wshShell.ExpandEnvironmentStrings( "%COMPUTERNAME%...
Thursday, June 9, 2011

create group users

›
net localgroup LD_user /add net user kshitij password /add /fullname:"Kshitij Rakesh" /expires:never /passwordchg:no net localgrou...

Replace String in text file

›
c:\> BatchSubstitute.bat "&Yourname" kshitij up78896.sql > up78896_new.sql ========== @echo off REM -- Prepare the Comma...
Friday, May 6, 2011

LD Billing Porcess Email Notification

›
CREATE OR REPLACE TRIGGER email_nsef_bill AFTER insert on TBLLOCKTABLE DECLARE b VARCHAR2(3) := UTL_TCP.CRLF; l_subject VARCHAR2(50) := ...
Thursday, May 5, 2011

Bulk Client Code Change prg

›
Set Exclusive OFF Set Date BRITISH Set Century on Set Talk OFF Set Safety OFF Close ALL Clear All Clear lcFirmnum='NBS-000001' gnQry...

LD AR > always release to AF > as per formula query

›
Client Master > Der+ Gen VI > Demat > Payout Status Quo Client Master > Der+ Gen VI > Default product > Status Quo AR >...
Wednesday, May 4, 2011

LD LOCKTABLE Email Notification

›
Select * From Tbllocktable Where Dcashbankfinancialentry Not Like ' '; ------------ CREATE OR REPLACE TRIGGER email_lock_table AFT...
Sunday, April 10, 2011

Create Control File Manually

›
CREATE CONTROLFILE REUSE DATABASE "ARI1112" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXI...
Saturday, April 9, 2011

Memory management SGA PGA

›
RAM=16 GB WINDOW PROCESS=16*20%=3.2 GB ORACLE SERVICES=12 GB PGA_AGGREGATE_TARGET==(RAM*80%)*50% FOR DSS PGA_AGGREGATE_TARGET==(RAM*80%)*20%...
Friday, April 8, 2011

SGA Tuning

›
There are two parameters SGA_TARGET: RAM SPACE IS ASSIGNED TO ORACLE SERVICES, CAN SEE ON TASK MANAGER PROCESS This parameter is new with O...

Oracle error 14402 : ORA-14402: updating partition KEY COLUMN would cause a partition CHANGE

›
The above error was caused because when you updated the record, it now belongs to a different partition but since row movement between parti...

PGA Tuning

›
Select Name,Value/1024/1024 From V$parameter where name like '%pga%'; Make a first estimate for PGA_AGGREGATE_TARGET , based on a r...

Kill Blocking Session

›
SELECT 'alter system kill session ''||ss.sid||','||ss.serial#||'';' FROM v$process pr, v$session ss, v$sql...

Contra Entry Zero Token

›
Cheque is expired after 6 months 31 Mar 2011 20110331 update cashmain set bankreco=20110331 where firmnumber='ACML-00001' AND CBNUMB...

Shrink datafile space from dropped table

›
Shrink datafile space from dropped table ================================================== select sum(bytes) / 1024 / 1024 / 1024 from dba_...

Primary key Constraints Enable

›
SQL> alter table CLJOBB disable constraint CLJOBB; associated index (CLJOBB) will be dropped automatically. SQL> alter table CLJOBB en...