Arvind Toorpu

Blog Posts

create shared disks (vdi) on Virtualbox for ASM – vboxmanage command line

June 19, 2017

vboxmanage command line For our scenario : Lets create shared disks (vdi) on Virtualbox for ASM setup. If you are getting error like below make sure you have virtual-box set in your environmental path: In my…
ORA-01113: file string needs media recovery

April 23, 2015

Learn how to resolve the ORA-01113: File Needs Media Recovery error in Oracle Database. Understand its causes, follow step-by-step resolutions, and apply best practices to prevent recurrence.
Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide

March 3, 2015

Learn how to configure email notifications for Oracle Scheduler jobs. This guide covers SMTP server setup, defining default senders, creating jobs, and setting up job notifications for proactive monitoring.
Trigger to backup the data before delete or update on a table – Oracle

February 10, 2015

Lets create a table : CREATE TABLE “ABC” ( “EMPNO” NUMBER(4,0), “ENAME” VARCHAR2(10 BYTE), “JOB” VARCHAR2(9 BYTE), “MGR” NUMBER(4,0), “HIREDATE” DATE, “SAL” NUMBER(7,2), “COMM” NUMBER(7,2), “DEPTNO” NUMBER(2,0) ) TABLESPACE “USERS” ;Now we will insert some data into it :Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,’SMITH’,’CLERK’,7902,to_date(’17-DEC-80′,’DD-MON-RR’),800,null,20);Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7499,’ALLEN’,’SALESMAN’,7698,to_date(’20-FEB-81′,’DD-MON-RR’),1600,300,30);Insert into ABC (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7521,’WARD’,’SALESMAN’,7698,to_date(’22-FEB-81′,’DD-MON-RR’),1250,500,30);Insert into ABC…
Generating Random Data in Oracle Tables for Testing

January 21, 2015

Learn how to use Oracle’s DBMS_RANDOM package to generate random test data for your tables. This guide covers random strings, numbers, and dates with PL/SQL examples.