Evaluate

Evaluate

Weigh the pros and cons of technologies, products and projects you are considering.

• Help building billion-row system

  I need to build a new system with a table that will keep data for 60 days (approximately 1 billion rows). Once the data is there, more data will be loaded (about 10 million rows per day). The system needs to reject and report this new data whenever ... Continue Reading

• Oracle unveils new tools for .NET developers

  Oracle has unveiled two new free downloads for developers of Microsoft .NET applications who want to get more out of Database 10g. Continue Reading

• Migrating data to legacy system as functional consultant

  What are the steps to be followed when migrating data from a legacy system as a functional consultant? What are the important interface tables that should be kept in mind? Continue Reading

• Service-oriented architecture: Realizing tangible benefit from SOA in the near term

  This introduction to service-oriented architecture (SOA) clarifies some basic terms, such as service and Web services, and provides an overview as to how your organization can begin to see benefits from SOA. Continue Reading

• Exporting large database with minimum access to system

  I need to export a large database with minimum access to the system, so I need to test my export script in isolation. This script gives me a warning that it has ignored the FILESIZE parameter and changed it to zero. What do you suggest? Continue Reading

• Taking backup of a table into a remote system

  How can I perform a database backup of a particular table into a remote system table at a specified time?Continue Reading

• Eight key Oracle developer tools

  Consultant Sridhar Bogelli provides a refresher on some of the key tools that developers use to customize Oracle E-Business Suite applications.Continue Reading

• Archive logs file system is exhausted

  This tip explains what to do if the disk file system fills up and the archiver is hung.Continue Reading

• Tool for migrating data between databases

  I need to migrate some data (maybe insert date on or after a certain date) in ORACLE_DB_1 to another Oracle database ORACLE_DB_2. Is there any tool to do this? After migration, the record will be removed from the ORACLE_DB_1.Continue Reading

• ORA-01078: failure in processing system parameters

  I'm getting the error message "ORA-01078: failure in processing system parameters."Continue Reading

• Releasing table lock

  How to release a table lock?Continue Reading

• Best tool for monitoring Oracle database

  For monitoring the Oracle database, which is the best tool, OEM Management Server or BMC Patrol for Oracle?Continue Reading

• New Oracle BI tool adds color to compliance efforts

  Oracle offers up details about its new Daily Business Intelligence for Compliance software.Continue Reading

• Migrate to base release first?

  I would like to know how to migrate from Oracle8i (8.1.7.4.0) to Oracle9i (9.2.0.5.0). Do I have to first do a migration to the Oracle9i base release (9.2.0.1.0) and from here apply a patch (for 9.2.0.5.0)? Or is there a better way to do this task?Continue Reading

• Advanced features of Oracle 10g

  What are the advanced features of 10g over Oracle9i?Continue Reading