Re: Indexes on Global Temporary Tables

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 27 Sep 2003 23:08:11 +0100
Message-ID: <bl51lm$q77$1$8300dec7@news.demon.co.uk>

Which version of Oracle, and do you get
any indication from the dbms_tts package that there will be a problem.

I cannot emulate your problem on 9.2.0.3

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____Finland__September 22nd - 24th
____Norway___September 25th - 26th
____UK_______December (UKOUG conference)

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA__October
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Sally" <sally_al2003_at_yahoo.co.uk> wrote in message
news:df28fc2a.0309220554.37d42bda_at_posting.google.com...


> My indexes created on Global Temporary Tables are being stored

> (according to sys.pluggable_set_check) in the system tablespace.

 The


> user creating these tables has no quota in the system tablespace.

 The


> system tablespace is not a default for the user.

>

> This causes problems with transportable tablespace exports, I am

> having to drop the temporary tables before I can do them.

>

> Oracle say this is not a bug :

>

>

> Has anybody else come across this, I can't find anything here, on

 Tom


> or with Oracle.

>

> I'm failing to see why it isn't a bug, could it fill the system

> tablespace, or is it just a marker and no "actual" space is used?

>

> Any information to enlighten me would be a great help.

>

> Thanks

>

> Sal.

Received on Sat Sep 27 2003 - 17:08:11 CDT