Opatch Failed error code 73: OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables"

Error Description:

Oracle SPU / CPU patch deployment using Opatch filed with following error message.

Following executables are active :
/u00/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u00/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2012-11-22_14-10-00PM.log

OPatch failed with error code 73

Data Pump Expdp Impdp Exclude Include Table Partitions – Table_data option

There are 2 ways to exclude and include table partition to the data pump utility.

1.   Is using data pump APIs. This technique I have explained in this post. Data Pump API

2.   Using exclude table_data option. I have mentioned one example below.

Create a table with partitions to test the expdp.

Reason for ORA-00439: feature not enabled: Partitioning

Error Description:

Create table command filed with following error.

CREATE TABLE EMP

*

ERROR at line 1:

ORA-00439: feature not enabled: Partitioning

Problem Description

The database portioning option works only with the enterprise edition not with the standard edition.

Create Jpg, png, PDF Oracle Database Schema ER / Table Relationship Diagram Using Data Modeler

Step 1. Open sql developer data modeler

Step 2. Navigate through File -> import -> data dictionary

Step 3. Click on Add button and provide the database connection details

Step 4. Connect to the database and click Next and the select the schema details

Step 5. Select the tables which you wanted to get the diagram and click finish.

The above steps will give you the ER diagram on the screen. From there you can easily generate the .jpeg,

Fill Maadi Win Aagi: Win Prizes from IOC Fuel Outlets

Indian Oil Corporation (IOC) introduced a new promotion campaign called "FILL MAADI WIN AAGI". If you are filling you fuel tank with Rs.500/- then you are eligible to participate in the campaign. There are lots of prizes waiting for you including 4 Tata Nano cars, Hero bikes, daily gifts etc.

What you have to do?

You have to get the electronically printed bills from the fuel outlet and send an SMS mentioned in the format mentioned in the fuel station.

The Format is

ORA-01732: data manipulation operation not legal on this view

Problem Description:

Oracle view DML operation fails with following error.

SQL> update vw_emp set ename ='xyz';

update vw_emp set ename ='xyz'

       *

ERROR at line 1:

ORA-01732: data manipulation operation not legal on this view

SQL> explain plan for update vw_emp set ename ='xyz';

explain plan for  update vw_emp set ename ='xyz'

Fix ORA-08189: cannot flashback the table because row movement is not enabled

Error Description:

Flashback table command failed with following error.

SQL> FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP('2013-10-28 12:00:00', 'YYYY-MM-DD HH24:MI:SS');

FLASHBACK TABLE test2 TO TIMESTAMP TO_TIMESTAMP('2013-10-28 12:00:00', 'YYYY-MM-DD HH24:MI:SS')

                *

ERROR at line 1:

ORA-08189: cannot flashback the table because row movement is not enabled

Oracle Create View Syntax: 9 Different Examples

1. Create Simple View with Selected columns of a table

SQL> create view vw_emp as

select empno, ename from emp;

View created.

2. Create a View with all columns of a table

SQL> create view vw_emp as select * from emp;