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

Thread: goofy LMT extent allocation

Threaded View

  1. #1
    newbie5 is offline Call me super inquisitive
    Join Date
    Jun 2002
    Posts
    178

    goofy LMT extent allocation

    create tablespace doe_support
    datafile 'D:\ora92\oradata\dcc1\doe_support.dat' size 100M
    autoextend on
    extent management local
    uniform size 500K
    segment space management auto;

    and I imported objects initially exported from this tablespace and I see this:

    OBJECT_NAME.....OBJECT_TYPE.....INITIAL_EXT...NEXT_EXT...

    UTILFUNC...........TABLE..........327,680......524,288...
    SECBRIEF...........TABLE.........4,259,840.....524,288...

    Why is the initial extents are 300K/4MB rather than the uniform size 500K?

    This is a newly created table space not a conversion from DMT?

    Can the create statement in import OVERRIDE LMT extent allocation?
    Last edited by newbie5; 02-07-2003 at 03:42 PM.

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