(Raj Thukral) Of late, Oracle has had the tendency to automate a lot of the usual DBA tasks.
Tag: Oracle
Hackers in your Database
(Steve Callan) Tinker, Tailor, Soldier, Spy comes to mind when the subject of database security comes up. How would you know if there was a mole in your database? A mole, in this context, refers to a malicious user who has hacked Oracle objects to cover his tracks, and much like the mole in John le
Importing extra columns as null values
(Maria Anderson) We are migrating our Oracle database to a new environment. There are some custom tables which are present in both the databases, but the new environment database has some extra columns in those tables. Could you please help me in using the export/import utility so that the extra col
Master Class Jonathan Lewis Cost Based Optimizer
(Gerwin Hendriksen) A couple of weeks ago I was at a MasterClass from Jonathan Lewis about the Cost Based Optimizer. It was a very interesting two days and I like to give some nice highlights on the masterclass.
Oracle throws weight behind embeddable DBMSs
(Mark Brunelli) Oracle is putting more resources and energy into the embeddable database management system (DBMS) market. (R)
Oracle 10g: A Simple Security Approach Part II
(JP Vijaykumar) Though the title says “A Simple Security Approach Part II”, the topics covered in this article are COMPLEX in nature. Welcome to the world of complexities in database access and security.
Migrating 9i database on Windows to 10g on SLES
(Maria Anderson) I have a 200 GB database running on Oracle9i release 2 on a Windows 2003 platform. We want to migrate the database on SLES 9 server Oracle10g rel2. Please guide me on the steps involved in doing this. (R)
Load Text Files to CLOB then Write Back Out to Disk – (PL/SQL)
(Jeff Hunter) The following example is part of the Oracle LOB Examples Collection.
Consider Oracle 10gR2’s Instant Client Light for application deployment
(Bob Watkins) Client/server applications can communicate with an Oracle database in several ways. The most common of these is a middleware layer called the Oracle Call Interface (OCI). As you install Oracle’s server software on the database server machine, you must install some sort of client softwa
Oracle Loses Would-Be Customer To SAP Due To Integration Concerns
(Mary Hayes Weier) SAP and Oracle are locked in a fierce battle over the enterprise-resource planning software market, with SAP fighting to retain its lead and Oracle hoping to catch up through an aggressive acquisition strategy.