By Boris Milrud – As counterintuitive as it is, Oracle databases have no SQL command for assigning a new name to a table column yet they have such a command for renaming an entire table. So, when I peruse Oracle database discussion groups, I frequently see the question “how do I rename a table colum

Oracle9i DBA Certified Professional Credential: Instructor-Led/Hands-On Course Requirement Deadline Extended to September 1, 2002

This script will copy archived redo logs to a secondary standby destination for an NT database.

By Matt Hicks – The state of California has ended its controversial enterprise licensing agreement with Oracle Corp. following months of legislative hearings and high-level resignations over a state audit report criticizing the deal.

By Sara Cushman – Defending their new DBA certification requirement against critics who say it’s costly and unnecessary, Oracle described the move as part of a new strategy to ensure that only top-shelf candidates receive the company’s stamp of approval.

by Galina Petrenko – This script produces readable output (backup) for database links in the database. It can be used in the restore/recovery process. Note that passwords for database links are also spooled in a readable format.

By Jack Shirazi – Transactions make a developer’s job a lot easier. By using the transaction capabilities within the JDBC API and relational databases such as Oracle9i, you can minimize possible data corruption when updating multiuser applications. Transactions require processing overhead, however,

By Jennifer LeClaire – In a move to compete with rival Oracle’s new 9i database management software, IBM has released a beta version of its new DB2 database. According to IBM executives, the latest software is faster and more reliable than its predecessor, with improved support for Web services.

By Michael Nazareth – The following creates the script enable_cons.sql that enables all disabled constraints. It must be run by Oracle user SYSTEM. It has been tested on Oracle 7.3 onwards.

by Paul Subash – Description: This code provides details about the activities of database users (except SYS) and runs under Oracle8, Oracle8i, and Oracle9i databases.