By Paul Krill – Application servers utilizing Web services and Java will enable integration of multiple information systems for e-business, according to an Oracle official.
Tag: Oracle
Oracle Updates Data Warehouse Tools
By Barbara Darrow – The newly updated Oracle9i Warehouse Builder tool claims to break down the walls between silos of corporate information. Version 9.0.4 can extract data from IBM’s DB2, Sybase, Microsoft SQL Server and Oracle’s homegrown database, said John Magee, vice president of product
Explain Away Your Troubles
By James Koopmann – Determining when things change in a database is the first step in zeroing in on problems. One of the prime culprits to change is the very SQL that we attempt to run every day. Here is a no-frills method to help sniff out those changes that occur.
Certifying: DBA Fundamentals II
By Jim DiIanni – This column includes a discussion of topics you will likely encounter on the Oracle9i DBA Fundamentals II exam. The Oracle9i DBA Fundamentals II exam is one of two that you must take to achieve the Oracle Certified Professional (OCP) level of certification. In this column, I’ll disc
Move tables between tablespaces
By Sergey Solodilov – This script generates a script that moves tables from one tablespace to another. Also, it rebuildes indexes of these tables and doesn an analysis. The script can be fixed for a range of sizes for tables and size extents for new tables. It is based on an article by Brian Peaslan
Oracle lends support to UnitedLinux
By Michael S. Mimoso – Oracle Corp. has entered into an agreement to provide level 1, 2 and 3 technical support for enterprise customers using UnitedLinux’s distribution of Linux. In addition to supporting its own products on the UnitedLinux distribution, it will also support the operating system.
Export TABLE Records into Flat File with INSERTs
by Dave Nikhil – This procedure writes an ASCII file to specified folder. UTL_FILE_DIR parameter must be set in the init.ora file prior to installing and running the procedure. This package looks for TABLE COLUMNS in USER_TAB_COLUMNS data dictionary. So user will be able to fetch the data onl
Protecting Oracle Instance with Local Clustering
Follow along with Marin Komadina as he explains the ins and outs of Local Clustering with Sun Cluster software.
Oracle deal: Good omen for Linux group?
By Sandeep Junnarkar – Oracle on Thursday lent UnitedLinux a hand in its turf battle with Linux leader Red Hat.The database heavyweight announced that it would provide technical support to customers who are using open-source software from UnitedLinux, a consortium of second-tier Linux compan
On the job with DBA Todd Barbera
By Sara Cushman – SearchDatabase.com kicks off a series of profiles featuring database administrators at work. Todd Barbera, a Boston-based DBA, tells us what his days are like, why he likes working in a small IT shop, and shares his on-the-job learning experiences.
