resizing datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: resizing datafile

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    resizing datafile

    hi folks,
    when i resize a datafile (when reducing the size), the size of the file is not decresed at the OS level, right ?
    why ?
    regards
    sonia

  2. #2
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hi,
    if resizing is possible on your OS then the size of the datafile
    is decreased on os-level.
    Because the size of the datafiles in the dictionary is the PHYSICAL size of the os-implemetation of the datafiles.
    Orca

    Someties resize has no result bcause some blocks 'live' at the end of the Datafiles even it is almost empty.
    Orca

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    But of course it is resized! What makes you think the opposite? What would be the purpose of resizing (schrinking) the datafiles if physical datafile size would not decrease?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Sonia

    Nope it is not true resizing at oracle level means..oracle server would make function call via the c program asking the OS to resize the datafile..every os does it...But before resizing oracle server would check the high water mark of the file..becasue you cannot shrink a datafile beyond its high water mark..

    If you oracle version is 7 and above you can shrink the datafile on all platforms..if it is not shrinking that means..you are

    a)either trying to shrink it belwo the high water mark
    b)You should till the os actually shrinks..there maybe a slight delay till you actually see the results..
    c)This also works on raw file systems


    regards
    Hrishy

  5. #5
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    It Does , Ofcourse

    Oracle Block = N * OS Block
    Datafile Extension is Based on Oracle Block size
    SO it means Datafile Extension is Based on N * OS Block
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

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