(Maria Anderson) We are upgrading our database from Oracle 8i to 10g on a Windows platform. Our production database is in 8i and the upgrade method we are using is imp/exp. The production box contains a lot of partition tables. If we export we will get the “rollback segment too small” error. So we a

(Arif Mohamed) The launch of Oracle E-Business Suite 12 last month is a major step towards Oracle’s first fully standards-based, service oriented architecture (SOA) suite, Fusion Applications due in 2008.

(Bob Watkins) The MERGE statement, introduced in Oracle 9i Release 2, is often called an “upsert” because it can both update and insert rows in the same pass. It’s a real timesaver for Extract, Transform, and Load (ETL) applications, such as loading a data warehouse. Rows that don’t already exist in

(Dratz) I’ve been thinking over the last couple of days of how best to try and explain bitmap indexes. It’s one of those topics where I thought I had a good explanation, then thought it wasn’t so good, then thought it was great, then wasn’t sure.

(Timothy Prickett Morgan) In the wake of Oracle’s Applications Unlimited” upgrade to four of its five software suites that happened two weeks ago, it seemed appropriate to reach out to the Independent Oracle Users Group to see what the users it represent think about Oracle and how it is taking care

(David A. Kelly) As businesses grow, their applications and business processes will need to work together seamlessly. Making that a reality is the mission of Oracle Fusion, Oracle’s vision for next-generation enterprise technologies, applications, and services. Part of that vision is Oracle Fusion A

(Tarry Singh) In our last article, we looked at the service architecture. We will continue our quest to understand the workload characteristics and the load balancing connections in our Virtualized RAC.

(David) A few days ago I ran into a problem with one of our development DB2 servers. A programmer in my team accidentally activated a Java Hibernate class with an option that truncates tables before loading them into memory. This resulted in most of our tables becoming empty (and I’m taking about so

(Jagadish Chatarji) In this article, I shall go through a set of PL/SQL stored procedures which are very frequently used for CRUD operations. These stored procedures are mainly helpful for the developers who develop client applications (involving business logic or user interface design and programmi

(Steve Callan) So much has been written about indexes that you practically need an index to keep track of things. Performance is the number one reason why indexes are needed. However, there are situations where indexes are not needed, so how do you know when and where to index? To index or not to in