By Arul kumar Ramakrishnan – This script can be used to generate a CREATE TABLESPACE script. It will be very useful in environments where it is required to recreate databases or simulate the existing database setup in a different environment. Just run this script and you will get the entire tablespa

(Andrejus Baranovskis) In my previous post, we learned how to handle replay conflict – Oracle Offline Persistence Toolkit – Reacting to Replay Conflict.

By Songini, Marc L – ORACLE CORP. is moving to centralize systems management, monitoring and performance-analysis operations for users of its databases and middleware.

By Barbara Darrow – Next month BMC Software plans to ship a version of its SQL-BackTrack backup and recovery tool that integrates with its SmartDBA Web management console.Company officials said the integration of the products would mean that backup and other management tasks can now be orche

By Srinivas Chittimalla – If you wish to find, for example, the number of employees by department, you can use the following query (using the standard demo tables in Oracle).

Compared to SQL Server, Oracle allows a DBA to go much further under the hood to properly manage data space requirements. However, space allocation in Oracle is complicated. Joe Lax shows you how locally managed tablespaces can let the database engine make most of the decisions for you.

By Jay Wrolstad – IBM and Sharp want to bring Linux to the mobile worker. Sharp’s strategy is to create an open standards Linux/Java platform with support for enterprise applications and databases from IBM, Microsoft, Oracle and Sybase, among others.

By Dilbagh Singh – This is a good tip indeed but it takes two or three steps before one can see the graph. Here is a Perl version of it that does the same with one click. It works very well except for the password part; I am using OPS$ id in the real script.

By Richard Karpinski – Oracle submitted a specification to the Java Community Process that it says could ultimately create a standard API for Java development tools, and has the potential to bridge competing open-source Java tool projects.

Steven Feuerstein examines substitutability and type conversion as he explores the advantages and flexibility of object-type hierarchies in Oracle 9i.