(Lewis R Cunningham) Regardless of any regulations you are required to meet you can implement a security and audit scheme that will cover you for most, if not all, eventualities. Having good security and auditability should be desirable regardless of regulations. It protects your business.

(James Koopmann) Up to now in this series on globalization, we have discussed how to set particular environment variables or database parameters. This was done to get our client machines configured in such a way that they truly represented their true locale and for the proper translation of char

The recommended method to upgrade from one Oracle release to the next is to use the Database Upgrade Assistant (DBUA). This document focuses on the upgrade part of DBUA from Oracle9i Real Application Clusters Release to the Oracle10g Real Application Clusters Release on Linux x86. (pdf)

(Scott Stephens) Many UNIX variants used system calls that operated on files with 32-bit unsigned integers to indicate file offset; these integers are limited to a range of 0 to 2 gigabytes. See how you can use Oracle’s split trick to export a file up to around 10 GB and still stay under the 2 GB li

(Lewis R Cunningham) This is the second entry of a three part series. In part one of this series, I defined what security is and what the different aspects of security in Oracle entailed. In this entry, I am going to show the technical details of implementing security in Oracle. I will create a

(Sanjay Mishra and Alan Beaulieu) There are situations when we need to combine the results from two or more SELECT statements. SQL enables us to handle these requirements by using set operations. The result of each SELECT statement can be treated as a set, and SQL set operations can be applied on t

Business Components for Java was designed to work with Oracle databases, and as such there are limitations when working with other databases. When you chose to work with a different SQL dialect, the framework automatically changes the SQL style to suit. However, you must be careful to use the approp

(Larry Greenemeier) Over the past few years, Oracle has been on one of the most aggressive shopping sprees the software industry has ever seen. The company may not be finished, but executives Monday paused to answer questions about Project Fusion, the crucial effort to combine the PeopleSoft, J.D. E

(Laurie Sullivan) Oracle laid out an 18-month road map late last week to beef up Retek’s service and development capabilities by infusing it with resources it could never have afforded on its own. Oracle completed its acquisition of the retail-management application vendor last week after a monthlon

The Oracle database has always been known as the industry leader in terms of performance and reliability, while at the same time providing extremely rich functionality. Most successful businesses today use the Oracle database to power their mission critical applications. However, as the business en