DatabaseJournal.com Staff

Introduction Oracle introduced the concepts of DIRECTORY objects in Oracle 8.0. DIRECTORY object is a logical structure that represents a physical directory on the server’s file system. Initially the DIRECTORY object was used only in context of the “DBMS_LOB” PL/SQL package, for administering and accessing files located under the directory identified by the DIRECTORY object. […]

Brian Carr and William Garrett Combine RAC, Linux and FireWire disk for low-cost development environment. Toolbox: Oracle 9i (9.0.1.4.0) Database Server with RAC option; Red Hat Linux 7.1. Topics include Oracle database installation, Linux kernel versions, and kernel settings. You should have a good knowledge of Oracle database administration and Linux (or UNIX) operating system […]

[From Microsoft] SQL Server 2000 Service Pack 3 (SP3) addresses specific issues discovered in SQL Server 2000 since its ship date. Because SQL Server Service Packs are cumulative, SP3 includes all fixes from previously released Service Pack 1 (SP1) and Service Pack 2 (SP2), and can be applied to an original installation or to one […]

Ajay Gursahani Oracle 9i’s Flashback feature, DBMS_FLASHBACK, provides the user with the ability to view data in a database “as it was,” at a specified point in the past, even though committed transactions have since been applied. The subprograms available under DBMS_FLASHBACK package are listed below: ENABLE_AT_TIME ENABLE_AT_TIME is used to ‘flashback’ to a specified […]

by Tim Perdue As my programming skills have improved over the years, I find myself demanding more precise and guaranteed control over my data. Simply inserting into the database and hoping for the best is not good enough anymore. Using transactions and foreign keys are good first steps in ensuring data integrity, but with some […]

Here’s a simple cursor script that will look for User objects and grant access to a user or group. The script could also be adapted to perform a REVOKE command rather than a GRANT privilege. It’s really an admin tool, but you could use it to trigger or limit a Database user’s application privileges. Really […]

This script extracts various details from SQL Server 7.0/2000 based on sysfiles and sysdatabases. It returns the server name, version of SQL Server, database name, device name, device location, and approximate size in MB of the device. The script is useful for monitoring file sizes and the existence of databases. The output is saved as […]

[From eWeek] OuterBay Technologies on Monday will roll out its Application Data Management suite, software that allows enterprises to monitor and manage data growth. The ADM suite consists of three key components: ARM (Application Resource Manager), Instance Generator and LiveArchive. ARM allows users to monitor, detect, diagnose and resolve data growth that’s gotten out of […]

[From PRNewswire] UniPress Software, Inc., a leading provider of web-based help desk and support automation software, today announced that its FootPrints(R) help desk software now supports the MySQL(TM) database for both Linux(TM) and Sun(R) Solaris(TM) platforms. Extending its portfolio of databases to meet the growing help desk and support needs of today’s mid-sized companies and […]

[From eWeek] Application Security Inc. on Monday rolled out an IBM DB2 version of its AppDetective application security vulnerability scanner. The scanning and penetration-testing software performs network-based penetration tests and security audits. AppDetective locates and identifies a variety of applications within a network, including those running on DB2 and Lotus Domino databases, as well as […]

Ajay Gursahani, ajay.gursahani@mahindrabt.com This article describes how to use job queues to schedule the periodic execution of user jobs, and contains the following topics: Viewing Job Queue Information Managing Job Queues Overview Routines (jobs) can be scheduled to run periodically using the job queue. To schedule a job, simply submit it to the job queue […]

[From eWeek] Protegrity Inc. is rolling out security packages for leading databases that combine software with cryptographic hardware to provide enhanced key management capabilities. The Secure.Data F3 package automates encryption and separates duties between database administrators and security officers, enabling centralized management of encryption parameters. Protegrity, of Stamford, Conn., will announce Secure.Data F3 for Microsoft […]