More Oracle Blogs

I just thought I'd mention that I've added a bunch more Oracle related blogs to the list down the right hand side of the page. I recommend that you give them a read. If you know of any others I should be reading (if only I had the time to read more) then feel free to comment here.

Comments

Post a Comment

Popular posts from this blog

SQL*Server Import Export Wizard 2017 vs Office 64 bit

Not Oracle, but since we're having to multi-platform these days, it might be relevant to some. When you install SQL*Server Management Studio on 64-bit Windows, the Management Studio (SSMS, equivalent of SQL*Plus) is 64-bit, but it installs the 32-bit version of Import Export Wizard (SSIS). This is fine if you have the 32-bit version of Office installed or only import and export CSV or other non-Microsoft file types. If you have 64-bit Office and try importing an Excel spreadsheet, you will get an error message: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)" Googling for this error message brings back a range of solutions (many dating back to SQL*Server 2008 and Office 2010), from installing the 64-bit Access Runtime redistributable to setting up a VM in Oracle Virtual Box and putting the SSMS/SSIS software on that, but not any form of Office. When I ran into this error today, we found, after some trial and err...
Read more

Preventing record deletion

This entry is partly an aide memoire for me, partly to try to get something that has been keeping me awake for the past hour or so out of my brain so I can sleep and partly in the hope that someone can suggest a way forward. A quick bit of background. Until April 06 most of our major systems were looked after by an external Faccilities Management company. In April 06 IT was kind of outsourced to a joint venture company, support of the systems transferred to that company and a couple of the DBAs transferred in as well under TUPE. A reccurring problem on one of the systems is that the users keep deleting records which, by law, they must not delete so we (actually one of the DBAs who transferred in who is responsible for that system) has to restore from backup to another machine and copy the deleted records over (she's tried using LogMiner but finds it too unwieldy). The core problem is that the application is faulty and lets the users delete the records when it shouldn't. The...
Read more

Oracle aims to secure future of Sparc, Solaris and Sun hardware

Interesting article on ComputerWeekly.com about how Oracle are looking to secure the future of Sparc, Solaris and Sun Hardware . They don't mention it but I wouldn't be surprised if we see 'Database as an Appliance' coming soon with Oracle Database running on Sun Hardware with management taken out of the hands of the local DBA and automated or made accessible only to Oracle themselves. This isn't a 'Death of the DBA' thing, the sort of sites that could go for something like that are probably the ones that don't have a DBA, just a support tech who has a couple of books, the sort of sites that probably run M$ SQLServer now. One thing they mention, as an aside, is that Oracle plan to OpenOffice.org to position it as a competitor to Microsoft Office. If they want to do that then I think the thing they really need to introduce to the suite is a desktop RDBMS to beat Access. Ideally something that can also act as a front end to Oracle with a tool that will...
Read more