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_at_ponyneedles.com> 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. ???
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2005 - 04:04:48 CDT
