(Sameer Wadhwa) In 24/7 database, it is hard to find out a maintenance window to do certain tasks like reorganize table, adding or dropping column, adding or deleting partition, move tables from one tablespace to another etc. Now in Oracle 9i, you can do this ONLINE without worrying to stop the use

Long running operations such as imports and batch processes sometimes fail because the server is unable to allocate more extents for an object. This may be because the object has reached max_extents or there isn’t sufficient room in the tablespace for the object to expand. In previous releases the o

(James Koopmann) Until Oracle decides to give DBAs built-in direct access to the alert log, it will always be our responsibility to continually check and maintain it. Here is a simple solution that will help with this most basic of DBA task. The Oracle alert log file is a chronological log of imp

A cluster is a schema object that contains one or more tables that all have one or more columns in common. Rows of one or more tables that share the same value in these common columns are physically stored together within the database. Generally, you should only cluster tables that are frequentl

(Brian Cryer) The apparent complete lock-up of the database. It is still possible to connect to the database, but any attempt to query it results in the application (or Oracle tool) locking up.

(Chris Claterbos) The OLAP option in Oracle9i Database Release 2 introduced analytic workspaces and the true integration of relational and multidimensional datatypes in the same database. Until now, the only way developers and DBAs could use the analytic workspaces was to construct them manually by

(Steven Feuerstein) In the previous six articles in this series, I’ve covered all the aspects of Codecheck related to extracting and analyzing argument information, but I haven’t yet touched on this small-but-crucial related aspect: reporting the results. In this article, I’ll step through the proce

(Ian Smith) There have been many requests for Oracle Rdb to generate unique numbers for use as PRIMARY KEY values. In Rdb 7.1 we chose to implement two models that capture the functionality of most SQL database systems on the market and reflect the current planning for the draft SQL Database Langu

(Steven Feuerstein) In this 8-part series, one of the world’s leading experts on PL/SQL explains how he created Codecheck, a PL/SQL utility that relies on information in the data dictionary to analyze packages for ambiguous overloadings.

(Susan Sales Harkins and Arthur Fuller) A logical model helps clarify your application’s domain by defining the necessary tables, the relationships between those tables, and their cardinality. At the logical level, each column’s attributes are defined, such as whether to accept null values, default