web analytics

Tagged: Oracle

ORA-00054: resource busy and acquire with NOWAIT specified 0

ORA-00054: resource busy and acquire with NOWAIT specified

A you are working on a busy database than you will often see this error.

Description

It means that your session is trying to update an ob

Informatica Admin Console not working. 2

Informatica Admin Console not working.

  After installation of Power Center 8.xxx Cannot start Admin Console. It hangs on the following local address. http://localhost:6001/adminconsole.   and after sometime it shows the annoying error of  “Page not found”. I have...

Calculating difference of dates in Oracle 0

Calculating difference of dates in Oracle

How to calculate difference between two dates in oracle, as subtraction of dates returns numeric value as difference. With some slight changes/enhancements we can track back the subtraction values to some readable date formats:...

ORA-38029 : object statistics are locked Recently 0

ORA-38029 : object statistics are locked Recently

This error comes when analyzing tables in oracle. Basic issue in this error is  when you import table without data i.e structure/schema only, oracle will lock table statistics. You can view all the locked...

Creating Table dynamically in Oracle Procedure 1

Creating Table dynamically in Oracle Procedure

How can we create a table inside an Oracle procedure. "CREATE TABLE tableName AS". We cannot execute this statement in procedures because upon creation of procedure it would give syntax error. We can implement...

Killing Locked Sessions in Oracle 2

Killing Locked Sessions in Oracle

Many a times user sessions are locked in some DML/DDL operation, than how to unlock those sessions because a new step or operation could not be done on the specific object that is locked....

Creating Custom Functions in Oracle 0

Creating Custom Functions in Oracle

Here it is a simple procedure to create and call a custom function in Oracle. A custom function is a simple PL/SQL subprogram that is used to calculate a value. It creation syntax is...

How to check Numeric value in Oracle 0

How to check Numeric value in Oracle

Currently i could not find any suitable function for checking numeric value on some column. There are many workarounds to achieve this functionality, either cast the column value in Numeric and check, but this...