(Yunyou Yao) When we developed web applications using .NET 2005 with an Oracle database there was a request from our customers. They wanted us to print reports with header and footer on each page, and convert the file to other file formats such as Excel. The requirement can be implemented using Crys

(Lewis Cunningham) I work in an environment that is not really a database shop. The DBA and I are really the only Oracle people on site. The rest are mostly business people and .Net developers. This is kind of weird since we’re a data warehousing and BI shop.

(John Pallatto) While most customers are still contending with the intricacies of Oracle Database 10g, Oracle officials here told attendees of the company’s OpenWorld show Oct. 23 that it was ready to launch the beta test version of its next-generation Database 11g.

(Jeff Hunter) Suppose your database is stored using ASM including all physical database files and the SPFILE. You already know and understand how to duplicate database files and even the control file from ASM to the local file system using RMAN (See Migrating Databases from non-ASM to ASM and Vice-V

(Mark Brunelli) If you’re choosing between “open source” and “closed source” to meet your company’s needs, stop — because there’s no need to differentiate the two anymore, according to speakers at the Oracle OpenWorld conference. (R)

(Mike Lampa) When trying to design a data warehouse, we often try to model the database on the operational data model. Are there any guidelines in trying to create a data warehouse based on the operational data model? (R)

(Tarry Singh) As promised, in this article we will check the syntax on our console. These commands are carried out against a working 4-node Oracle 10g R2 cluster. The OS is RHEL 4.2/Centos 4.2 running on Virtual machines, on an ESX Server. Each server has 1200MB RAM, Dual CPU or better said as 2 vCP

(Alex Gorbachev) If you are using Oracle Data Pump to backup tables containing LONG or LONG RAW columns, then you might be surprised when trying a recovery. Well, you tested it already. Didn’t you?

(Bill Brenner) A week after digesting Oracle Corp’s October critical patch update (CPU), database administrators (DBAs) are giving Oracle’s revamped bulletin mixed reviews. Oracle fixed 101 security flaws in its latest update, which included a new and improved bulletin with more details on the numbe

(Shakir Sadikali) There’s been a fair bit of discussion with respect to whose vegetables are the freshest in Ottawa. From one DBA to another, I’m here to tell you that St. Laurent Fruit and Vegetable (beside the Mideast Meat Market) is probably the place to go for the best prices on… well… fruits an