Not all companies use the latest and greatest database versions, OS, etc, so I thought I'd publish a bunch of old scripts I used back in the day (they were very useful to me when I was an Oracle DBA). They were mainly for Oracle 9i and 10g.
I haven't used them in quite a long time, and am not in a position to test them now, so please bear this in mind if you decide to use any of them.
| Oracle 9i and 10g Administration Scripts | |
|---|---|
| Delete duplicate rows from a table | |
Loading...
Time permitting, this website will have a bunch of content added that will hopefully provide useful hints for getting things done quickly during your Data Engineering activities. I've worked in the IT business for over 30 years, as a Developer, Lead Systems Analyst, Database Designer, Database Administrator, and Data Architect.
In each of these roles I have sought to embrace time-saving practices that really do make a difference - for example, comparing data in different databases ... write a script to do it (Java/Python). It's not rocket science, it's just realizing that if you need to perform a task, and you envisage it being done repeatedly, then why not generate some reusable code. Pretty much all of us think this way, and quite a few of us independently create our own toolbox of utilities, so I thought it might be an idea to get some of the more repetitious stuff out there to help save time.
Mark Harrison.
On Demand Reporting Limited.
