Re: datafile removal

NOOOOOOOOO!!!!!! don't remove the datafile!! A little extreme in the response but I just wanted to get the point across. The purpose of having more than one datafiles is for performance and back-up reasons. Performance: If you have two disks with one datafile each (of the same tablespace) then you will have a faster response of I/O. So when Oracle reads data from the datafiles, it obtains the information faster because the I/O is distributed. Back-Up: Let's say a datafile got corrupted or deleted...It is much faster to recover a 500MB datafile from tape than it is to recover a 1GB datafile. So if my tablespace had two 500mb datafiles, I would recover either datafile faster than if I had one huge datafile.

Hope this info helps you...also, don't think you can out smart Oracle by changing any information of the datafiles (such as Time Modification), Oracle is very good in keeping data integrity intact.

Good Luck,
Satar Naghshineh

In article <3606A9D1.35BA8B7F_at_hrb.com>,   Kevin Kirkpatrick <kjk_at_hrb.com> wrote:
> I was wondering what would happen if I went to remove one of the two
> datafiles from my tablespace? Is this safe, meaning that Oracle will
> move data from one datafile to the other one and then remove it? I am
> not exactly sure what the advantages of having two datafiles are, I
> guess you could shut one down while the other is online but what is the
> point of doing this? Is there a way that you can control what goes into
> a particular datafile? If it is possible to shift a table or something
> like that into a datafile, then I could see the point. Can that be
> done?
>
> Thanks
> Kevin
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 22 1998 - 10:49:35 CDT