URGENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: URGENT

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by shailendra

    I THINK IT SHOULD CONSIDER THE PARAMETER AT TABLESPACE LEVEL.
    Why? Object storage always trumps tablespace storage.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2000
    Posts
    305
    ok marist89

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

    thanks

    Shailendra

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    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
  •  



Click Here to Expand Forum to Full Width