Techgoeasy

Step by step upgrade process for R12.2 Upgrade Part -1

R12.2 Upgrade consists of following part Pre Upgrade preparation steps Main upgrade using Main Upgrade Driver for R12.2.0 (merged with pre-installed Oracle E-Business Suite Consolidated Upgrade Patch for R12.2.0) Online Patching Enablement Applying the latest R12.AD.C.Delta.n and R12.TXK.C.Delta.n Applying 12.2.n Release Update Pack (RUP) We will be taking care of step 1 in this post. […]

Step by step upgrade process for R12.2 Upgrade Part -1 Read More »

Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.x Release Update Pack)

Oracle, Oracle Ebuisness Suite

Step by step upgrade process for R12.2 Upgrade Part -4(Applying 12.2.x Release Update Pack) Read More »

Step by step upgrade process to R12.2 Upgrade part -3

Oracle, Oracle Ebuisness Suite

Step by step upgrade process to R12.2 Upgrade part -3 Read More »

Enabling Large Pages on Oracle Database running on IBM AIX

Oracle, Oracle Database

What is Large Pages and How it benefits Oracle database on IBM AIX AIX support two virtual page sizes: 4 kilobytes (standard page) and 16 megabytes (large page). When using large pages to map virtual memory, there are fewer page boundaries, which improve the performance of prefetching. Both online transaction processing (OLTP) and data

Enabling Large Pages on Oracle Database running on IBM AIX Read More »

ORA-00001 unique constraint violated

Oracle, Oracle Sql

ORA-00001 unique constraint violated is one of the common messages we often get while loading data. This ORA-00001 unique constraint violated error occurs when You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. Check list to run to resolve ORA-00001 We can

ORA-00001 unique constraint violated Read More »

How to create table as select in oracle

Oracle, Oracle Sql

oracle create table as select A table can be created from an existing table in the database using a sub query option. The table is created with specified column names and rows retrieved by the select statement are inserted into the table if the table column specification is not given, table is created with the

How to create table as select in oracle Read More »