Lazycoder

Oracle just ain’t no damn good

There’s No Place Like 131.107.2.200: Oracle keeps on sucking

Matthew is having some problems with Oracle. I don’t know why he would inflict that kind of pain upon himself, but my guess is it’s client driven. Damn clients.

I briefly had to work with Oracle 8i at a previous job. I couldn’t figure out any of their gui tools, half of them wouldn’t install correctly and I think it took about 2 hours to get to the point where I realized I couldn’t install them. (This was back in the Win2K days, not the halcyon days of hmmmm, damn guess I’m still using Win2K. In any case RAM was more expensive so we didn’t have a lot.) I ended up just writing all my DB creation scripts in ViM and running them in SQL+(I think that’s right).

Then they laid off the DBA, who promptly too the admin password with him off to Vegas (Las Vegas, NM). Of course when we called him up and asked him for the password he couldn’t remember it. Thus began our forced migration to SQL Server. I couldn’t log into any admin interface in Oracle, but we did have a user account that had read access to all of the databases. Yay! So I ended up linking them Oracle server to my SQL Server and using DTS to migrate the data over.