WHAT VERSION OF TOAD SHOULD WE USE?

WHAT VERSION OF TOAD SHOULD WE USE?

We don’t get this particular question per se as often as one would expect, but we do see enough user problems where this fundamental issue becomes the underlying question to answer for problem resolution. Below is a chart for the release dates for both Toad and Oracle. The “blue highlighted” dates are when Oracle first releases a major new version, such as Oracle 10g in January of 2004. But it’s the “red highlighted” dates that are more significant – as these are what Oracle calls the “terminal release” for a database version, such as 10.2.0.4. That’s the version Oracle treats as the mainstream one that it expects its users to standardize upon – especially for support purposes. In fact an Oracle tech support call where you’re not on the terminal release probably has an above average likelihood of ending with the advice to upgrade to see if that fixes it. Thus look again below, there are four key Oracle versions of which one should be the version that your database server is on. Also note that both Oracle 8i and 9i are essentially unsupported products at this time for most people (unless you have a specific and special extended support agreement with Oracle – and these are neither cheap nor common, so don’t just say yeah we have that).

So what version of Toad should you be using? That’s easy – one that came out around the time (and preferably after) your database terminal release version. So that’s why I’ve highlighted four Toad versions in red boxes below. If you’re trying to use Toad 7.6 with and Oracle 9i, 10g or 11g database – then you’re just asking for problems. Stay current on your maintenance and Toad upgrades are free. Don’t live dangerously – Toad 9.6 or 9.7 should be your standard for most cases these days. Happy Toad’ing to you all …..

For more Details Please visit http://www.orafaq.com/wiki/TOAD_Product_Review