IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: August 2007

XSLT Programming

Leave a Comment Posted by on August 31, 2007

XSLT = XSL Transformations XSLT is the most important part of XSL. XSL stands for EXtensible Stylesheet Language. XSLT is used to transform an XML document into another XML document, or another type of document that is recognized by a browser, like HTML and XHTML. Normally XSLT does this by transforming each XML element into [...]

XSLT

ORA-04091: Table is Mutating

14 Comments Posted by on August 30, 2007

Many a times you must have encountered the issue ORA-04091: table SYSTEM.TEST1 is mutating, trigger/function may not see it. This issue basically persists in PLSQL triggers. At one time I was also hit by the same issue. One of my friend “Nikhil Tungare – PLSQL Guru” helped me to get rid of this issue. Here [...]

Oracle Database 10g

Oracle Database 11g New Features – ASM

1 Comment Posted by on August 30, 2007

Oracle Database 11g extends the functionality of Automatic Storage Management (ASM)in following areas ASM Fast Mirror resynchronization: When we take a disk offline in case the disk is corrupted or database is not able to read or write from the disk. In case of Oracle database 10g, oracle engine use to balance the other disks [...]

Oracle Database 11g

Installing Oracle Data Mining Manually

1 Comment Posted by on August 27, 2007

Oracle Data Mining is one of the component of Oracle Database. When we create a database using DBCA it creates this component automatically. Even when we go for basic installation there is an option to select or de-select Oracle data mining. While doing Advanced installation, you need to go to “Custom” option on “Select Installation [...]

Oracle Database 10g

Using Javascript DOM in Web Applications

Leave a Comment Posted by on August 21, 2007

Many times while creating the web applications its not always a good idea to store even a small information in database tables. For Example if you have drop downs in your application and you want to populate the same from the lookup table in database. You web application, possibly written in JSP have to make [...]

JavaScript

Javascript – Hide/Unhide the content

Leave a Comment Posted by on August 17, 2007

Javascript Development: Developing a smart tool and a good user interface is really crucial. As a core DBA or Apps DBA we never think of any core programming exercise. But during the journey through database, we may come at a stage where you are required or expected to develop some really cool tools using JSP [...]

JavaScript

RMAN – Recovery Manager for Oracle Database 10g

16 Comments Posted by on August 10, 2007

WHAT IS RMAN ? Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them. WHY USE RMAN ? No extra costs …Its available free RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups [...]

Oracle Database 10g

Upgrading database to 10.2.0.3.0

4 Comments Posted by on August 6, 2007

Introduction and scope: This document is intended for those which are having 10.2.0.2 database installation and intended to upgrade the same to 10.2.0.3, by applying 10.2.0.3 patchset. This document is based on Metalink note ID 316900.1. Follow the below procedure for upgrading the database from 10.2.0.2 to 10.2.0.3 Pre-Requiste: We are assuming that you have [...]

Oracle Database 10g

Follow

Get every new post delivered to your Inbox.

Join 156 other followers