By Ed Parry – When Oracle announced it was getting into the hosting business in a big way, it wasn’t kidding. The company is turning into an outsource to be reckoned with.Oracle has cut the ceremonial ribbon for its 9i Database and Application Server hosting and managing services. The servic

by: jai Tanwar – If you are running a number of schemas under one service — which is usually the case — and you need to move all the tables belonging to a particular schema to a new tablespace, then this script is for you.

by Marius Nicoras – Last year I wrote “Another way to have your own aggregate function” ( Tip for Week of October 28, 2001 ) on the string data type as an alternative to a solution using object types ( Tip for Week of May 20, 2001 ). Now, in Oracle 9i, using XMLType I can build a DML statement […]

By Pravesh Gupta – Sometimes you may need to do an insert or update in the same table on which your trigger fires, resulting in a “Mutating Table” error. This can be avoided by writing a procedure, function or package that declares the pragma autonomous_transaction. The transaction is thus not visib

By Hervé Deschamps – Forms 9i New Features (My Favorite Ones), Forms9i Obsolescence Features, Designer 6i, UNIX.

By Antone Gonsalves and Rick Whiting – Oracle, looking to boost sagging revenue by expanding its software hosting business, next week will unveil a service to entice customers to leave their data with Oracle. The Oracle Outsourcing Upgrade targets customers running their businesses on versions 10.7

By Matt Hicks and John S. McCright – Moves by Oracle Corp. and IBM to embed new business intelligence functionality in their database management systems are designed to improve performance and simplify data warehousing. But they could also add unwanted complexity.Release 2 of Oracle’s 9i dat

By Prakash – Updatable Snapshots, a feature of Oracle Enterprise Edition only, is the snapshot, or copy, of a table, or part of a table. This copy can also be updated. Thus, updatable snapshot sites can also propagate any changes made upon them back to the parent.‘Updatable Snapshots’ should

By Tim DiChiara – A few weeks ago, I called upon you loyal SearchDatabase readers to submit your toughest questions to stump our site experts. We received over a hundred questions — I knew the modern DBMS was complex, but wow! The experts’ responses ranged from a confident “None of them really pose

The Computer Emergency Response Team Coordination Center (CERT/CC) Friday warned of multiple vulnerabilities discovered in Oracle servers, ranging from minor to serious. The CERT security advisory is titled “CERT Advisory CA-2002-08 Multiple Vulnerabilities in Oracle Servers.”