Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tablespaces using tempfile and concurrent insert/update

Re: Temporary tablespaces using tempfile and concurrent insert/update

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 28 Feb 2006 01:37:46 GMT
Message-Id: <pan.2006.02.28.01.36.18.943399@sbcglobal.net>


On Mon, 27 Feb 2006 15:54:06 -0800, Noons wrote:

> You're confusing extent management (LMT) with segment management.
> You need the latter to get rid of freelist management issues.
> It's the SEGMENT SPACE MANAGEMENT [AUTO|MANUAL] option
> of CREATE TABLESPACE.

One can not create ass managed (thanks, Pete S.!) temporary tablespaces:

  1 create temporary tablespace temp1
  2 extent management local uniform size 4M   3* segment space management auto
SQL> /
segment space management auto

                         *

ERROR at line 3:
ORA-30573: AUTO segment space management not valid for this type of tablespace

As you can see, Oracle kicks ass right out of the picture for the temporary tablespaces. If anyone finds my language objectionable, I'm not a native English speaker and my English is sometimes ridden with mistakes.

-- 
http://www.mgogala.com
Received on Mon Feb 27 2006 - 19:37:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US