Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tablespaces using tempfile and concurrent insert/update
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
*
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.comReceived on Mon Feb 27 2006 - 19:37:46 CST