RE: DATAFILE??

 >>You cannot drop datafile.

Alter database datafile '......' offline drop. BUT this is intended to be used when ultimately one will drop the tablespace also.

Chris Marquez
Oracle DBA

-----Original Message-----
From: Yavor Ivanov [mailto:Yavor_Ivanov_at_stemo.bg] Sent: Tuesday, October 18, 2005 10:58 AM To: Marquez, Chris; Oracle Mailing List; oracle.tutorials_at_gmail.com Subject: Re: DATAFILE??

        You cannot drop datafile.

        There is no such command on OPracle SQL. Or, at least, I don't know it?

        About the algorithm - I guess, and I am almost sure, that Oracle gets the first available chunk of free space large enough to hold the whole new-created extent.

	Rgds,
	Yavor

On Tue, 18 Oct 2005 17:49:25 +0300, Marquez, Chris <cmarquez_at_collegeboard.org> wrote:

> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yavor Ivanov
> Sent: Tuesday, October 18, 2005 5:23 AM
> To: Oracle Mailing List; oracle.tutorials_at_gmail.com
> 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_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. ???
>>
>> 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
>
>

--
http://www.freelists.org/webpage/oracle-l