Database

ORA-00001: unique constraint (string.string) violated

The ORA-00001: unique constraint (string.string) violated error comes when you try to update or insert a record in a table(Oracle Database) that creates a duplicate on the columns which are defined as unique. As per Oracle error message guide, ORA-00001: unique constraint (string.string) violatedCause: An UPDATE or INSERT statement attempted to insert a duplicate key. For …

ORA-00001: unique constraint (string.string) violated Read More »

ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction

The ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction error comes when you issue alter session enable parallel DML command when some transaction like an update, insert, delete is in progress. A transaction completes when you either issue Commit or Rollback. What is ORA-12841? As per Oracle Error Message Guide, ORA-12841: Cannot …

ORA-12841: Cannot Alter The Session Parallel DML State Within A Transaction Read More »

ORA-12154: TNS could not resolve the connect identifier specified (Solved)

ORA-12154: TNS could not resolve the connect identifier specified error comes when you try to connect Oracle database using clients/tools like SQL Plus, Toad, Oracle Forms, Oracle Reports, and SQL*Net could not find the alias specified for a connection in the TNSNAMES.ORA file or other naming adapters. Now, let’s reproduce the error and find out …

ORA-12154: TNS could not resolve the connect identifier specified (Solved) Read More »

How to Create Materialized View in Oracle Apps 12.2.5 (R12)

Materialized views are the database objects in Oracle based on SQL Queries. Unlike the normal view, MV actually contains the data. The generic statement to create a Materialize View is, CREATE MATERIALIZED VIEW viewname [options] AS SELECT ….. While working on Oracle Apps 12.2.5 where editioning or online patching is enabled, you need to use …

How to Create Materialized View in Oracle Apps 12.2.5 (R12) Read More »

How to Install Oracle Developer Suite 10G On Windows

Oracle Developer Suite 10G provides Forms Developer, Designer, Reports Developer, and Oracle 10g JDeveloper tools. These tools let developers quickly build high-quality transactional applications, which can be deployed to multiple channels – including portals, web services, and wireless devices, and which can be extended with business intelligence capabilities – including ad hoc query and analysis, …

How to Install Oracle Developer Suite 10G On Windows Read More »