(Matt Hines) Oracle has again increased its cash offer, but says this will be the last attempt to acquire its rival. Oracle said that it has increased its cash offer for enterprise software maker PeopleSoft to $26 per share, presenting its rival’s shareholders with a $9.4bn hostile takeover bid.

(Frank Pantaleo) This tip is about using LogMiner to replicate data between a production instance and a remote instance. The biggest advantage is this technique does not require any changes to the production instance if you are just capturing inserts. If you want to capture updates/deletes there are

(Arup Nanda) Over the last 27 years, Oracle has made tremendous improvements in its core database product. Now, that product is not only the world’s most reliable and performant database, but also part of a complete software infrastructure for enterprise computing. With each new release comes a some

(Sanjay Ray) This is an extension to the code tip that I supplied on 21 December 2003, “Comparing Contents of Two Tables with Identical Structure.” The following script highlights the columns that are different in the two tables, so there is no need to compare each column individually. The columns v

(Shahid Hafeez) This script will get the number of rows per table in the current schema. (script)

(Jim Czuprynski) I won’t harp on the obvious: The ability to access recent, consistent backup files and archived redo logs is the key to recovering from and surviving a disaster. Of course, I am assuming your production database is running in ARCHIVELOG mode for maximum flexibility for recovery. Mor

SQL standards have been the most popular and enduring standards in computing. Although information processing has become increasingly more sophisticated and more complex over the past decades, SQL has continually evolved to meet the growing demands. As the latest version of SQL standards, SQL 200

(Evagoras Charalambous) While it may be relatively easy to create an incrementing and unique identifier inside a table in SQL Server, things get tricky with Oracle. In this article, we’ll see the differences between the two databases and offer a way of solving the problem.

(Jutay Medeiros) This procedure generates a report and, if you want, an UNDO script using LogMiner (for Oracle8i and Oracle9i). I think that I can improve this procedure, but this is the first step. I hope all of you enjoy this procedure. Note: You must define the UTL_FILE_DIR parameter before runni

(Mark Rittman) Oracle Express has for many years been the industry’s leading OLAP server, offering unparalleled functionality, query performance and application support. With Oracle 9i, Oracle has taken the best features of Oracle Express and embedded them in the database kernel. By moving to Or