OraFAQ Forum: Server Administration » ora-25147 at the time of specifying uniform size with LMT

Home » RDBMS Server » Server Administration » ora-25147 at the time of specifying uniform size with LMT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-25147 at the time of specifying uniform size with LMT [message #150622]

Thu, 08 December 2005 13:52

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Hi,

I am getting the following error at the time of creating LM Tablespace with uniform size of 1M .

ORA-25147: UNIFORM SIZE value greater than maximum extent size .

when i specify the equivalent size or size greater than this in Kb,it accepts.Please justify.And ...What is the maximum size that can be given to an extent??

Regards,
reena

Report message to a moderator

Re: ora-25147 at the time of specifying uniform size with LMT [message #150669 is a reply to message #150622]

Fri, 09 December 2005 00:20

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I was able to replicated your problem , did you try something like this.

SQL> create tablespace dumm datafile '/data/dumm01.dbf' size 1M
2 uniform size 1M;
create tablespace dumm datafile '/data/dumm01.dbf' size 1M
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required

But if you increase the size of the datafile ,

SQL> create tablespace dumm datafile '/data/dumm01.dbf' size 10M
  2   uniform size 1M;

Tablespace created.

Its happening because

Quote:

When you allocate a datafile for a locally managed tablespace, you should allow space for metadata used for space management (the extent bitmap or space header segment) which are part of user space. For example, if you do not specify the SIZE parameter in the extent management clause when UNIFORM is specified, the default extent size is 1MB. Therefore, in this case, the size specified for the datafile must be larger (at least one block plus space for the bitmap) than 1MB.

regards

[Updated on: Fri, 09 December 2005 00:21]

Report message to a moderator

Re: ora-25147 at the time of specifying uniform size with LMT [message #150707 is a reply to message #150669]

Fri, 09 December 2005 03:22

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Hi Tarun,

I am specifying the datafile size as 10MB. Please check the following code and output.

1 create tablespace test13
2 datafile 'c:\test13.dbf' size 10M
3* extent management local uniform size
SQL> /
extent management local uniform size
*
ERROR at line 3:
ORA-25147: UNIFORM SIZE value greater than maximum extent size

Here ,I specified size clause without actually specifying the size my mistake. But using this syntax, what is the size it is trying to create?? I think it should report as a wrong syntax instead.

Regards,
reena

[Updated on: Fri, 09 December 2005 03:31]

Report message to a moderator

Re: ora-25147 at the time of specifying uniform size with LMT [message #150730 is a reply to message #150707]

Fri, 09 December 2005 06:13

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Actually the syntax is wrong, it needs a slight modification.
And the default extent size for uniform is 1M.

Now see this

SQL> create tablespace tab1 datafile '/data1/tab1.dbf' size 10M
  2  extent management local 
  3  uniform size;
uniform size
           *
ERROR at line 3:
ORA-25147: UNIFORM SIZE value greater than maximum extent size


SQL> create tablespace tab1 datafile '/data1/tab1.dbf' size 10M
  2  extent management local
  3  uniform;

Tablespace created.

SQL> select tablespace_name, initial_extent from dba_tablespaces
  2  where tablespace_name='TAB1';

TABLESPACE_NAME                INITIAL_EXTENT
------------------------------ --------------
TAB1                                  1048576

Dont ever specify size keyword if you dont want to specify size.

regards,
tarun

Report message to a moderator

Re: ora-25147 at the time of specifying uniform size with LMT [message #150738 is a reply to message #150622]

Fri, 09 December 2005 06:23

reena_ch30
Messages: 100
Registered: December 2005

Senior Member

Thanks a lot for your help.

Regards,
reena

Report message to a moderator

Previous Topic:	Startup and shutdown databases
Next Topic:	ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:35:06 CDT 2024