|
| |||
Oracle, SQL, PL/SQL, Microsoft SQL Server and T-SQL related Tips and Techniques |
|
Understand and Learn with example: Cause: An arithmetic, numeric, string, conversion, or constraint error occurred. For example, this error occurs if an attempt is made to assign the value NULL to a variable declared NOT NULL, or if an attempt is made to assign an integer larger than 99 to a variable declared NUMBER(2).
Oracle Export utility provides a number of options to help you export your data for different scenarios.
Here are some examples of the most common options that Developers/DBAs use.
Step by step instructions with images for each step of Oracle 11g Client installation process. This guide will teach you how to install Oracle 11g Client
This script will re-compile all invalid objects of all schemas in yuor database. This is quite powerfull script as it will try to re-compile everything in the database that is invalid. So you must need to run this script as a highly priviledged user (such as SYS or SYSTEM or a user with DBA role)
The script first builds up the ALTER commands for all invalid objects and put (spool) the list into an operating system file called templist.sql. The ALTER commands will be of the format
ALTER PROCEDURE CALL COMPILE;
ALTER PACKAGE PKG_TEST1 COMPILE BODY;
ALTER PACKAGE PKG_TEST1 COMPILE BODY;
Then the list file templist.sql will be run against the database to run all this commands in one go. Which means you just need to run this one script to re-compile all your invalid objects in your schema. Note that I am using here USER_OBJECTS – which is a VIEW owned by SYS user.
Learn facts about this error and how may you overcome if you encounter this error. This article gives a real life example of this happening in the Authors Oracle environment.
