Oracle

Pythian OOW09 Diaries: Interviews

I got a special press badge this year, I felt I had to do something about it so I decided to make short interview with few people that I’m running into during this Oracle Open World. I have already blogged about my Sunday’s interviews but I created a Youtube playlist where you can see them all (use arrows on the sides).

Pythian OOW09 Diaries: Bloggers Meetup

Thanks to all the bloggers for coming and sponsors for sponsoring! If you were on that meetup – make sure you blog about it, post you photos and publish the photo on *your* t-shirt to the community (yeah, you can take it off the wall this one time).

Oracle Restart Silent Installation

I had had some experience with silent (and not always successful) installation of Oracle versions 8 and 9, but thanks to an excellent post, Oracle Silent Mode, Part 1: Installation Of 10.2 And 11.1 Databases by Grégory Guillou, I got a new splash of joy using silent installations. RDBMS, Oracle Grid Control, agents, scheduler agents, collaboration software, etc., can be installed using the silent installation in latest versions. This post is about silent installation of one of the new Oracle 11g Rel.2 options called Oracle Restart.

ORA-01555: snapshot too old, When Running Flashback Query

Of all the frustrating, partially-completed features Oracle has released, this is the most frustrating. Did I mention this frustrating feature is frustrating when you get bitten by it?What am I referring to? FLASHBACK QUERY on a table that lives in a database with a large UNDO_RETENTION specified with lots and lots of UNDO_TABLESPACE space. Why is this behaving this way? Silly me, I really should read Oracle docs more carefully.Here’s what they say at Managing Undo for Your Database…There you have it folks. Please don’t get bitten with this the way I did.

OOW09 Diaries: The Week Before

Most of this week I spend in San Francisco — I arrived on Wednesday with couple other Aussie Oracle ACE Directors, Chris Muir and Marcel Kratochvil. This year I have my whole family traveling with me so it should be fun.

Free and Easy Schema diff for Oracle

This post originated from a quick discussion we had internally on how to quickly and easily compare schemas between two Oracle databases. I learned about Sheeri Cabral’s post with a quick comparison solution for MySQL databases and I though of using a similar approach for Oracle. I did some testing and it worked quite well. There certainly are tools in the market, free or not, that do this for us, and even generate scripts to correct differences. The steps below only go as far as to tell you what the differences are. However, they don’t require any additional tool and can be easily executed in any *nix or Windows environment.

Page 77 of 140« First Page...10...7576777879...90...Last Page »