URGENT

[shailendra]

HI FOLKS

I AM FACING ONE PROBLEM I HAVE A TABLESPACE [LOCAL MANAGED UNIFORM]. THE PROBLEM IS THAT WHEN I CREATE A TABLE WITH SOME STORAGE PARAMETER IT IS NOT TAKING THE DEFAULT PARAMETER OF THE TABLESPACE IT IS CONSIDERING THE STORAGE PARAMETER OF THE TABLE.

I THINK IT SHOULD CONSIDER THE PARAMETER AT TABLESPACE LEVEL.

PLEASE GIVE YOUR ADVICES

SHIALENDRA

[marist89]

Originally posted by shailendra

I THINK IT SHOULD CONSIDER THE PARAMETER AT TABLESPACE LEVEL.

Why? Object storage always trumps tablespace storage.

[shailendra]

ok marist89

tell me one more thing why the bytes and the initial extents are differnet when i create an object.

thanks

Shailendra

[Sameer]

Object storage parameter always overrides default storage parametres of tablespace, in both types of tablespaces.... locally managed or dictionary managed..

Only different is, in case of locally managed uniform allocation, it allocated number of uniform extents of defined size, to fulfil the need of required extents specified at object level storage defination.

Originally posted by shailendra
ok marist89

tell me one more thing why the bytes and the initial extents are differnet when i create an object.

didn't you read your y'days thread

http://www.dbasupport.com/forums/sho...threadid=28706