unable to extend index|table by 64000... - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: unable to extend index|table by 64000...

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by vishal sood
    Though it is(Autoextend) very useful feature but what I mean to say is, if we use Autoextend option the Oracle will itself extend the size of datafile after reaching MAXEXTENTS. If someone(lazy DBA) never checks the used/free space related things then one day he may find that the datafile has been ocupied/extended up to the whole avaialble space.

    Errr what amxextents you are talking about...? There is no such thing called maxextents at tablespace level!

    You set extent limit for segments, maxsize for datafile... what´s wrong?

  2. #12
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by ngwh
    ohh..u mean if auto-extend is ON .. for version 7.3.4 onwards ORACLE itself will create a new datafile once file size limit has been reached? interesting...hee
    Ok, what you are talking about too! Since when Oracle add datafiles by itself?!

    When we talk about auto-extend we mean datafiles not tablespaces!

  3. #13
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    pando,

    what i meant is even with auto-extend on..if lazy DBA doesn't chk the OS filesize...u'll still hit problem..which is y auto-extend shld be off and DBA performing constant chk which is preferred as u r in control

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    And I said there is this parameter called MAXSIZE....

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