Re: Howto Create global temporary table in Oracle 8.0.5

From: <bdbafh_at_gmail.com>
Date: 14 Dec 2005 14:07:59 -0800
Message-ID: <1134598079.433629.156820@g14g2000cwa.googlegroups.com>

> It looks like a new feature in Oracle 8i
> How can I create a temporary table in Oracle 8.0?

<troll>
set compatible to 8.1.7.0.0 and restart the database instance, perhaps? </troll>

You can't get there from here.

You'd be far better to do this in 9.2.0 or later, where optimizer dynamic sampling can sample stats for the GTT at runtime. You might even consider upgrading all of the way to 10.1 and apply the 10.1.0 patchset 2 (10.1.0.4) and CPUOct2005 patchsets. You might even consider upgrading all of the way to 10.2.

-bdbafh Received on Wed Dec 14 2005 - 16:07:59 CST