Arvind Toorpu

Blog Posts

  • How to Resolve TNS-03505: Failed to Resolve Name Error in Oracle

    How to Resolve TNS-03505: Failed to Resolve Name Error in Oracle

    Learn 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

    Fixing ORA-31633: Unable to Create Master Table During Data Pump Import

    Learn 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.

  • Understanding Data Pump IMPDP TABLE_EXISTS_ACTION Options: APPEND, REPLACE, SKIP, and TRUNCATE

    Understanding Data Pump IMPDP TABLE_EXISTS_ACTION Options: APPEND, REPLACE, SKIP, and TRUNCATE

    Learn about the Oracle Data Pump TABLE_EXISTS_ACTION parameter and its options: SKIP, APPEND, TRUNCATE, and REPLACE. Understand how to handle existing tables during imports with practical examples and best practices.

  • 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 used to get this weird error when ever I used to do check out.  …

  • Duplicate values in a table

    Create 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) VALUES (’15’, ‘f’);INSERT INTO ABC (ID, NAME) VALUES (’11’, ‘B’);INSERT INTO ABC (ID, NAME) VALUES…

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.

Recent posts