From oracle-l-bounce@freelists.org Tue Oct 18 04:04:48 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9I94lPa025001 for ; Tue, 18 Oct 2005 04:04:47 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9I94gvX024972 for ; Tue, 18 Oct 2005 04:04:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DF7B6207438; Tue, 18 Oct 2005 04:04:38 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09689-05; Tue, 18 Oct 2005 04:04:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 62B62207472; Tue, 18 Oct 2005 04:04:38 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=L8YL9O4BfiNin8xVFjbMF+31dVn43v9TZZjRrKMWj8m+d5i6euXbiRxOOZACjh/5cxFIvJRCz6Z/67gbZwloi1RHnucmBHetD2rHgL2c6NZ+ULikBph56skLTuTd+TbwqJ/3+ttzKlQ6zlPYLQpaWxHYEHRRjcdyzlZRjKE8nR0= Message-ID: Date: Tue, 18 Oct 2005 10:02:40 +0100 From: David Sharples To: compute@ponyneedles.com Subject: Re: DATAFILE?? Cc: Oracle Mailing List In-Reply-To: <03cc01c5d3bf$ec50f4f0$64000050@NEWDOMAIN> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10589_7833115.1129626160009" References: <03cc01c5d3bf$ec50f4f0$64000050@NEWDOMAIN> X-archive-position: 27113 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: davidsharples@gmail.com Precedence: normal Reply-To: davidsharples@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_10589_7833115.1129626160009 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 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. ??? ------=_Part_10589_7833115.1129626160009 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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 sp= ecific file.
 
What are you trying to find out?
 
On 10/18/05, computer centre <compute= @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 dataf= iles 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 s= tored
in the database? I mean in which file out of the 5. Is it done ran= domly?
Is there any query r method to find out in which datafile the dat= a is
stored.
All the files r online.    ???

------=_Part_10589_7833115.1129626160009-- -- http://www.freelists.org/webpage/oracle-l