Re: Indexes on Global Temporary Tables

From: Yong Huang <yong321_at_yahoo.com>
Date: 16 Oct 2003 11:34:33 -0700
Message-ID: <b3cb12d6.0310161034.6bf584c@posting.google.com>

sally_al2003_at_yahoo.co.uk (Sally) wrote in message news:<df28fc2a.0310150712.5a5ec64a_at_posting.google.com>...
> Sally wrote:
>
> > So why should the GTT show as in the system tablespace?
> >
> > The work around is to delete all temporary tables before doing a
> > Transportable export but it's just annoying that I don't understand
> > why pluggable is showing what it is.
>
> An update for your info: This is a bug that is fixed in 9.2, and I'm
> hoping for a backport fix for 8.1.7.4.
>

Hi, Sal.

Please provide the bug number or any reference we can find on Metalink. And use correct terminology when you say "delete all temporary tables"; DELETE MYTABLE means DELETE FROM MYTABLE. You probably meant DROP TABLE MYTABLE?

Yong Huang Received on Thu Oct 16 2003 - 13:34:33 CDT