RE: DATAFILE??
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>, "Oracle Mailing List" <ORACLE-L@xxxxxxxxxxxxx>, <oracle.tutorials@xxxxxxxxx>
- Date: Tue, 18 Oct 2005 12:14:49 -0400
>>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@xxxxxxxx]
Sent: Tuesday, October 18, 2005 10:58 AM
To: Marquez, Chris; Oracle Mailing List; oracle.tutorials@xxxxxxxxx
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@xxxxxxxxxxxxxxxx> 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@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.
>>
>>
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
