Re: Question about resizing a tablespace

Possible disk file fragmentation. If the datafile is alone in it's own volume, then it will not fragment (unless you have some sort of weird dynamic-sizing volume, which is doubtful as you are appear to be using NT). NT will fragment them even if backed up/restored UNLESS they are on their own volume which you can reformat between backup and restore.

AW

W. Scott Moore <sirws_at_hotmail.com> wrote in message news:BWnP4.121$g53.8580_at_news.uswest.net...
> What are the ramifications of increasing the size of a datafile?
>
> for example, my 'users' tablespace/datafile is 25M and I want to increase
 it
> to 100M
>
> alter database gpro
> datafile 'e:\oracle\gpro\users.ora'
> resize 100M
>
> Does this cause fragmentation and other issues that can affect
 performance?
>
> Any info/insight would be greatly appreciated.
>
> Thanks,
> Scott
>
>
Received on Tue May 02 2000 - 00:00:00 CDT