Home » SQL & PL/SQL » SQL & PL/SQL » MAXEXTENTS
MAXEXTENTS [message #194928] Tue, 26 September 2006 04:00 Go to next message
Claud
Messages: 17
Registered: July 2006
Junior Member
This code creates a Tablespace for dimension in my Data Warehouse

-- Tablespace for Dimensions
CREATE TABLESPACE easy_dim
DATAFILE 'C:\oracle\product\10.2.0\oradata\EASYDW\dimensions.f'
SIZE 5m REUSE AUTOEXTEND ON
DEFAULT STORAGE
(INITIAL 16k NEXT 16k PCTINCREASE 0 MAXEXTENTS UNLIMITED);

Why there is an error message
ERROR at line 1:
ORA-03249: Uniform size for auto segment space managed tablespace should have atleast 5 blocks

so when i change 0 MAXEXTENTS to 5 MAXEXTENTS, to code works.
what is that means? and also what MAXEXTENTS actually means for?

I need anybdy help for this problem.
Thanks alot.

[Updated on: Tue, 26 September 2006 04:09]

Report message to a moderator

Re: MAXEXTENTS [message #195279 is a reply to message #194928] Wed, 27 September 2006 14:29 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
I find it highly unlikely that changeing the 0 to a 5 will remedy your error, as...

It's not 0 MAXEXTENTS, it's PCTINCREASE 0 and MAXEXTENTS UNLIMITED
Please do not use PCTINCREASE parameter as it is an ancient legacy parameter.
Don't bother giving ANY storage parameters and let Oracle manage it for you. See what happens when you try to fine-tune these storage parameters?
The error lies with your INITIAL and NEXT extent size of 16k. It's too small.

and this is a Server Administration question. Where is the PL/SQL in this question?

[Updated on: Wed, 27 September 2006 14:30]

Report message to a moderator

Re: MAXEXTENTS [message #195347 is a reply to message #195279] Thu, 28 September 2006 02:36 Go to previous messageGo to next message
Claud
Messages: 17
Registered: July 2006
Junior Member
Thanks joy!
Oh yeah I see, sorry for my mistake about the abbreviated =)
and then what is actually PCTINCREASE for?
could you tell me?
so what syntax should i use later?
Re: MAXEXTENTS [message #195349 is a reply to message #195347] Thu, 28 September 2006 02:39 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
PCTINCREASE specifies how much bigger each extent should be than the previous one. It was an early approach to sutomatic extent management, as tables that required frequent new extends would rapidly get larger and larger extents added, keeping the number down.

As @joy_division said, it's functionally obsolete these days.
Previous Topic: select in one line
Next Topic: join strings
Goto Forum:
  


Current Time: Fri Dec 09 17:51:43 CST 2016

Total time taken to generate the page: 0.24033 seconds