-
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
-
Originally posted by shailendra
I THINK IT SHOULD CONSIDER THE PARAMETER AT TABLESPACE LEVEL.
Why? Object storage always trumps tablespace storage.
Jeff Hunter
-
ok marist89
tell me one more thing why the bytes and the initial extents are differnet when i create an object.
thanks
Shailendra
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|