-
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
-
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
-
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?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|