Oracle Cast Function: ORA-01438: value larger than specified precision allowed for this column

Error Description:

Oracle SQL query with cast function failed with following error message.

SQL> select cast(deptno as numeric(1)) from dept;

select cast(deptno as numeric(1)) from dept

            *

ERROR at line 1:

ORA-01438: value larger than specified precision allowed for this column

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'