This tip comes from Wayne Zhu is a Sr. Database Administrator in Philadelphia, PA.

This task of data cloning is quite common in any testing or tuning environment. Obviously, it requires some technique to automate it.

(Ofer Harel) There are some situations when a critical data or rollback segment is locked, but you cannot find the blocker session. In those cases you can suspect an in-doubt transaction. When you use the two-phase commit mechanism — such as using a joined query with dblink — there are some situat

By Joris Evers – Oracle is adding a component for creating sales proposals to a new version of its Oracle Sales software scheduled to be announced next week , the company said. The new component, called Oracle Proposals, is meant to cut down the time a sales representative works on drafting s

By Antone Gonsalves – Oracle is working with China’s leading Linux developer in building support for the open-source operating system in all of Oracle’s product lines.

By John Geralds – Linux was the talk of the Oracle database user conference in the US last week, with firms looking at evaluating or moving corporate applications with database servers to run on the open source operating system.

by Romer L. Vinuya – Normally, table columns with system-generated values contain numeric data (e.g. 00001, 00002, and so on). The code combines alphanumeric sequence in a column that increment even the alphabet value when the numeric value reaches the maximum. Create the table and trigger below and

(Glen Stromquist) While doing a database restructure for the purpose of upgrading a client, I had a need to restore the database from backup several times because of a flaw in the applications database restructure program. After the second time, I wrote a quick little script to create a restore.bat

By Stephen Shankland – Database giant Oracle has chosen Intel to supply crucial programming tools called compilers for creating software that runs on servers using Intel processors. The move is one of several steps Intel is taking to improve the software’s utility.

By Charles Babcock – The company’s AppsRules product lets Oracle financial and ERP apps users build a business-rules layer above their applications that’s integrated across them.