Re: DATAFILE??

A question to your question.
 Why does it matter? - you store data in a tablespace which is made up of
datafiles. So when you write data it is written to a datafile in specific
file.
 What are you trying to find out?
 On 10/18/05, 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. ???

Other related posts: