(Alf Pedersen) Oracle recovery makes is possible to restore a physical backup and reconstruct it, and make it available to the Oracle server.
Tag: Oracle
Oracle To Bring Siebel CRM To Linux
(Barbara Darrow) When Oracle releases Siebel 8 later this year, the venerable CRM application will, for the first time, run on Linux servers.
On storing hierarchical data
(René Nyffenegger) The canonical approach to store hierachical data is to create a self referencing table…
Getting rid of runaway temporary tablespace – 8 Gb reclaimed
(Lucas Jellema) Even though we keep telling ourselves that iron these days is cheap, I was having difficulties with my laptop’s hard disk. It was almost full – to the brim. I discovered a while back that my Oracle database files took up an alarming amount of diskspace, especially given the pathetica
Oracle RAC Administration – Part 6: Administering the Database Instances and Cluster Databases
(Tarry Singh) Oracle has finally released its Oracle 10G Release 2 database for Solaris 10. I have been waiting for it for quite some time and I hope that they were able to fix the clusterware problems, which had had some issues. Anyway, I will test it on my ESX box, which has three ready baked Sola
Oracle block corruptions, DBV vs RMAN
(Paul Moen) Dear Diary, Is that a whiff of decay in the air, the pungent odour of corruption? No… not me, the database.
Oracle’s Security Plans
(Lewis Cunningham) Information Week has an article out today, Oracle’s Security Blanket. The article talks about Oracle’s plans for security in the future, including some thoughts about security in Fusion.
Achieving higher availability with Flashback Database
(Jeffrey R. McCormick) Flashback Database is a new approach to point-in-time (PIT) database recovery. This incomplete recovery strategy can be used to recover a database that has been logically corrupted due to human error. Introduced in 10g, it is designed to maximize availability by reducing recov
Generate external table definitions from SQL*Loader
(Bob Watkins) External tables, introduced in Oracle 9i, enable you to map a sequential text file to an Oracle table definition. Once the external table is defined, you can use the full power of the SQL SELECT statement—including parallel querying—to process it.
Drilling GL sub-ledgers
(njethwa) In this article we will see how to drill from GL balances to Journal Details and into Sub-ledger transactions. We will also see how all these things fit together in an Operational Finance Dashboard.
