-
Configuring Scheduler Email Notifications in Oracle: A Step-by-Step Guide
Continue reading →: Configuring Scheduler Email Notifications in Oracle: A Step-by-Step GuideLearn 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
Continue reading →: Trigger to backup the data before delete or update on a table – OracleLets 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…
-
Generating Random Data in Oracle Tables for Testing
Continue reading →: Generating Random Data in Oracle Tables for TestingLearn 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.
-
How to Resolve TNS-03505: Failed to Resolve Name Error in Oracle
Continue reading →: How to Resolve TNS-03505: Failed to Resolve Name Error in OracleLearn how to troubleshoot and resolve the Oracle TNS-03505: Failed to Resolve Name error. This article covers common causes, step-by-step troubleshooting, and best practices for ensuring a successful Oracle connection.
-
Fixing ORA-31633: Unable to Create Master Table During Data Pump Import
Continue reading →: Fixing ORA-31633: Unable to Create Master Table During Data Pump ImportLearn how to resolve the ORA-31633: Unable to Create Master Table error in Oracle Data Pump Import. This guide covers troubleshooting steps, necessary privileges, and best practices to ensure a successful import.
-
Svn client error svn: E160006: Invalid revision number ‘-1’
Continue reading →: Svn client error svn: E160006: Invalid revision number ‘-1’Topic : svn: E160006: Invalid revision number ‘-1’ I have recently come across this error when I installed the svn client on my machine. I have the latest version of tortoise svn client on my local machine. After install I…
-
Duplicate values in a table
Continue reading →: Duplicate values in a tableCreate table sql : CREATE TABLE ABC ( ID NUMBER , NAME VARCHAR2(20 BYTE) ) ;Lets insert duplicate values into it: INSERT INTO ABC (ID, NAME) VALUES (’15’, ‘f’);INSERT INTO ABC (ID, NAME) VALUES (’15’, ‘f’);INSERT INTO ABC (ID, NAME)…
-
grant permissions on all tables to a user
Continue reading →: grant permissions on all tables to a userGrant select permission on all tables in logged in schema to a user/role: declarecursor c1 is select table_name from user_tables;cmd varchar2(200);beginfor c in c1 loopcmd := ‘GRANT SELECT ON ‘||c.table_name||’ TO &&YOURUSERNAME’;execute immediate cmd;end loop;end; Note :you change the select…
-
adding a primary/unique key to existing table and updating values
Continue reading →: adding a primary/unique key to existing table and updating valuesLearn how to add a primary/unique key to an existing Oracle table and update its values using sequences. This article provides clear steps and PL/SQL examples to automate assigning sequential IDs.
Oracle ACE Pro · AWS Community Builder
Arvind Toorpu
Oracle Certified Professional and Cloud Ops Database Manager at a financial services firm. Fourteen years architecting and running Oracle, SQL Server, PostgreSQL and MySQL estates, including migrations of hundreds of databases to AWS, Azure and OCI.
This blog is the tuning, recovery, security and migration work behind that — written up as it actually happened, errors included.
Oracle ACE Pro 2026 · AWS Community Builder 2026 · Oracle Certified Professional
Oracle · SQL Server · PostgreSQL · MySQL | AWS · Azure · OCI | Awards · Publications
Browse by topic
Oracle · Backup & Recovery · Administration & Maintenance · Security & Auditing · Cloud & Migration · Performance & Tuning · SQL Server · PostgreSQL & Aurora · All topics →
Latest writing
Hello,
Arvind Toorpu
I am a Database Admin/Architect with over 14+ years of experience managing multiple DBMS systems
Let’s connect
Join the fun!
Stay updated with our latest tutorials and ideas by joining our newsletter.
