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.
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.