-
One of the basic tasks of a DBA is to multiplex the Control Files. One of the biggest reasons why we multiplex control files is to create backups of the primary control file, which “records the physical structure of the database.” When the control file is damaged there is no way you can bring it back...
-
My New Year's Resolution List: 1. Prepare For The MCTS-SQL Server 2005 Certification (70-431) 1.a Self-Paced Training (Training Kit + Videos Lessons) 2. Prepare For The OCA Exam (1Z0-042) 2.a Review Oracle 10g Architecture and Administration 2.b Attend Class For the Oracle 10g Backup and Recovery...
-
I came across this error ORA-00904 : "GetTotalItem": invalid identifier when I tried to call a local function inside a dynamic query. I am currently working with Oracle database (we’re using Oracle 9i). My task is to add additional field (TotalItem) in the existing query in the StoredProc1...
-
While surfing the Net and unconsciously thinking about my standing in the I.T. market, I came across a link that tells Frequently Asked Questions about Java and Oracle. I'm still browsing through it while making this blog post. What's the fuss? Well, two of the latest job interviews I've...