Oracle Basics

From Eddie’s blog I got a link to 3 posts on Regular Expressions on OTN written by CD. Wonderful stuff. Check out. Part 1 Part 2 Part 3 & Thanks CD…wonderful work buddy ! Comments Comment by Tyler on 2008-02-28 07:51:45 +0530 I’ve been working with regular expressions in PL/SQL a lot lately and the one tool that’s helped me more than any other is Regex Buddy (http://www.regexbuddy.com/). Yeah, it’s not free, but it was the best $40 I’ve spent. There are free options, like regex coach and a few free online options, but the problem is you have to find one that matches the Oracle specific Posix ERE format. Regex buddy even has a drop-down for Oracle syntax (http://www.regexbuddy.com/oracle.html). I have no affiliation with this tool whatsoever, just found it to be exceptionally useful. ...

Howard has posted a pdf on Oracle Administration on his new website. Do check out. Its awesome. Update: Howard has shutdown his website, so unfortunately this pdf is not available. Sidhu Comments Comment by Amritpal Singh on 2008-01-22 11:03:00 +0530 paaji no pdf, all the content is password protected. Comment by Sidhu on 2008-01-22 21:54:00 +0530 Due to some reasons Howard has password protected all the content 🙁 Read more at http://tinyurl.com/yvypmj ...

Eddie Awad started a new series Oracle in 3 minutes on his blog. In the first post he has discussed about multi-versioning. Its a must watch for everyone who is working on Oracle. Hoping to get more of such stuff from Eddie. Sidhu Comments Comment by Amritpal Singh on 2008-01-22 11:05:00 +0530 nice man, keep posting all the good work. Comment by Sidhu on 2008-01-22 21:55:00 +0530 Thanks man 🙂 Sidhu

Today, I was following a thread on Oracle Forums. Someone asked a question about UNDO tablespace wrt to a scenario. The question was: There is a database and its hot backup is taken on Friday. Now for Saturday, Sunday and Monday there are archive logs but no backups. Suppose the machine crashes on Monday. After we restore the database to Friday (from backup), recovery will happen. As UNDO tablespace is of Friday so it has no information related to transactions that happened on Saturday, Sunday and Monday. So in the end of recovery process when we need to rollback some transactions from where that required information will come ? ...

A very nice series of articles by Howard Rogers about Oracle Concepts. It includes all the basics like what a database, instance is ? Various types of files and all basic stuff. Read it here Sidhu Comments Comment by Anu on 2011-06-01 12:16:50 +0530 Hi Amardeep, Am a newbie for Oracle and was searching for Howard Rogers articles. I found your post but It doesn’t have his articles anymore, When i click the link. It will be great if you can send me if the correct link or where can i find them or mail me if you have any. ...