I don't know...thought about it, never cared to investigate, never *needed* to know. But what is Oracle algorithm for disbursing data amongst available datafiles? I do know that in every shop I've been, if someone (more experienced DBA) accidentally adds a datafile they would just resize it to very small size...the inexperienced DBA (I've done it too) drops that datafiile leaving a hole. Chris Marquez Oracle DBA -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yavor Ivanov Sent: Tuesday, October 18, 2005 5:23 AM To: Oracle Mailing List; oracle.tutorials@xxxxxxxxx Subject: Re: DATAFILE?? I guess you are trying to do some load-balansinag and the 5 datafiles are on diferent storage groups? Because I cannot think of another case when datafile matters. So I *think* is is possible to track down the datafile by rowid, but is is quite hard work. But even if you find out where do you insert, you do not have _any_ control over this. And since it is only for looking purposes, you may use v$filestat. Rgds, Yavor On Tue, 18 Oct 2005 11:42:50 +0300, computer centre <compute@xxxxxxxxxxxxxxx> wrote: > Hi TO ALL > > I have a doubt. Plz do reply. We have an Oracle 10g R1 db running here. > we have 5 datafiles of 2 gb each. Now we use Oracle Forms as front end. > Now as the daily transactions carry on i want to know how the data is > stored in the database? I mean in which file out of the 5. Is it done > randomly? > Is there any query r method to find out in which datafile the data is > stored. > All the files r online. ??? > > Plz do reply > > Thank You > > Imran Mohajir > NIIPL. > > > DISCLAIMER: > This message and any attachment(s) contained here are information that > is confidential, proprietary to Needle Industries (India) Private > Limitied and its customers, privileged or otherwise protected by law. > The information is solely intended for the individual or the entitiy > it is addressed to. If you are not intended recipient of this > message, you are not authorized to read, forward, print, retain, copy > or disseminate this message or any part of it. If you have received > this e-mail in error, please notifiy the sender immediately by return > e-mail and delete it from your computer. Although precautions have > been taken to ensure no viruses are present in this mail, Needle > Industries (India) Private Limited cannot accept responsibility for > any loss or damage arising from the use of this e-mail or attachments. > > > > > -- > http://www.freelists.org/webpage/oracle-l > > -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l