Robert Hanrahan) This procedure generates two scripts that do a hot backup and restore of the database. It is a full backup of the database datafiles, redolog, init, and control files. You can run this script at database open and it will generate 2 files: (R)

Have you downloaded Oracle trial software from Oracle Corp.’s Web site? Are you having any problems? Do you have any questions? OracleInstall provides installation assistance and technical information for Oracle’s free trial software. This information is available to you from Oracle’s Web sit

By Margaret Kane – Lexmark has been forced to swallow a $15m loss after an Oracle customer relationship management project went awry.

by Riju George – With reference to your tip for the week 08/04/2002 submitted by Madan Patil, this is another way of deleting duplicate rows from a table. The difference being the time it takes to delete the duplicate rows with this method is many times faster than the earlier method.

By John S. McCright – Embarcadero Technologies Inc. aims to make it easier to manage computing environments that run databases from several vendors.Upgrades to the company’s DBArtisan and SQL Debugger tools will let database administrators manage and develop applications across IBM, Oracle C

Oracle’s strategy to increase its hosted application revenue is paying off for the software giant — thanks to a motivated sales force and cost-conscious enterprise customers.

By Cary Millsap – Performance management consists of problem diagnosis and repair, resource management, applications optimization, and capacity planning. In constructing a reliable performance management method for hundreds of Oracle database sites, my colleagues and I have encountered bits of inter

This new edition by PL/SQL experts Steven Feuerstein and Bill Pribyl covers all versions of PL/SQL, from Oracle 7.3.4 to Oracle 9i Release 2. It includes new chapters on creating and running PL/SQL programs, calling Java methods from within PL/SQL, and defining and using database triggers, as well a

By David Nishimoto – The DBMS_SQL package can be helpful for executing dynamic SQL. Dynamic SQL can be either a DML (Dynamic Manipulation Language: select,insert,update,delete) or DDL (Data Definition Language: create table, create index, or create view).

By Tom Smith – Lumigent Technologies Inc. on Monday detailed Log Explorer for Oracle, software that identifies causes of data corruption and is used to recover critical business data by enterprises using Oracle databases.