No failover is involved. And I don't assume that I know the motivation. I know the motivation because I asked. And I have permission to ALTER TABLESPACE because I've been administering Oracle databases since 1987.
--- Tim Gorman <[EMAIL PROTECTED]> wrote: > Um... > > It depends on whether those whining staff DBAs are managing a > failover > environment. If you created that datafile on a file-system in a > "non-failover" (not "failover-enabled") volume group, especially when > rollback segments are involved, then you've just ensured an > un-open-able and > un-recoverable database in the event failover should occur. > > Congratulations! It's not everyone who can do that so easily! > > If you haven't considered that, then I have to question why you have > the > permission to ALTER TABLESPACE. Don't assume that you know > everybody's > motivations... > > There. I feel even better... :-) > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, April 05, 2002 7:53 AM > > > > What happens when you run out of disk space on a mount point? It > > happened to me. I created a new datafile on another mount point, > and > > then had to hear staff DBAs whining, "why is there a rollback > segment > > tablespace file on /u004?", as though it was a major disaster. > Really, > > when people get into this mindset of "file A MUST be in directory > B", > > they lose all sight of what they should be doing (ensuring a > smoothly > > running database) and concentrate more on whether every file is in > the > > right place so that they don't have to query the data dictionary. > > > > OK, I feel better now. :-) > > > > > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > > > I had an SA teach me that one, and it's saved me from making a > REALLY > > > stupid mistake a number of times. > > > > > > As for your client's standards, I can see why they want to impose > > > standards and that's a good thing. But they are a bit too rigid > with > > > it, as others have said, what happens if you run out of disk > space on > > > a > > > mount point? > > > > > > I probably have bored most of the people on this list to death > with > > > this, but I still believe that the ONLY way to make sure if a > > > datafile > > > is part of the database is to query the database. All you need is > one > > > forgetful person who misplaces or misnames a file. > > > > > > Rachel > > > > > > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > > > > > > > > That's a great idea. Henceforth I'm going to do the same! > Thanks. > > > > > > > > > > > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > > > > > and, on a Unix box, I ALWAYS do an "fuser" before deleting a > > > file. > > > > > Just > > > > > in case. > > > > > > > > > > > > > > > --- Jonathan Gennick <[EMAIL PROTECTED]> wrote: > > > > > > On Tue, 02 Apr 2002 07:43:34 -0800, you wrote: > > > > > > > > > > > > >Great point. I had recently created a DB file and forgot > to > > > put > > > > > the > > > > > > ".dbf" > > > > > > >extension on it. If someone didn't query the DD of the DB > > > > first, > > > > > > they might > > > > > > >have thought it was a junk/temp file (they would have to > > > ignore > > > > > the > > > > > > file's > > > > > > >timestamp) and deleted it. > > > > > > > > > > > > Yeah, naming convention or no, I can't imagine not looking > > > > > > at v$datafile or dba_datafiles just to be sure. > > > > > > > > > > > > Jonathan Gennick --- Brighten the corner where you are > > > > > > mailto:[EMAIL PROTECTED] > > > > > > http://Gennick.com * http://MichiganWaterfalls.com * > > > > > > http://ValleySpur.com > > > > > > -- > > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > > -- > > > > > > Author: Jonathan Gennick > > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) > > > > 538-5051 > > > > > > San Diego, California -- Public Internet access / > > > Mailing > > > > > > Lists > > > > > > > > > > > > > > > > > > > -------------------------------------------------------------------- > > > > > > To REMOVE yourself from this mailing list, send an E-Mail > > > message > > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') > > > and > > > > in > > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > > > (or the name of mailing list you want to be removed from). > You > > > > may > > > > > > also send the HELP command for other information (like > > > > > subscribing). > > > > > > > > > > > > > > > __________________________________________________ > > > > > Do You Yahoo!? > > > > > Yahoo! Tax Center - online filing with TurboTax > > > > > http://taxes.yahoo.com/ > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > > -- > > > > > Author: Rachel Carmichael > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) > > > 538-5051 > > > > > San Diego, California -- Public Internet access / > Mailing > > > > > Lists > > > > > > > > > > > > > -------------------------------------------------------------------- > > > > > To REMOVE yourself from this mailing list, send an E-Mail > message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and > > > in > > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > > (or the name of mailing list you want to be removed from). > You > > > may > > > > > also send the HELP command for other information (like > > > > subscribing). > > > > > > > > > > > > __________________________________________________ > > > > Do You Yahoo!? > > > > Yahoo! Tax Center - online filing with TurboTax > > > > http://taxes.yahoo.com/ > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > > -- > > > > Author: Paul Baumgartel > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) > 538-5051 > > > > San Diego, California -- Public Internet access / > Mailing > > > > Lists > > > > > > > > -------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, send an E-Mail > message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You > may > > > > also send the HELP command for other information (like > > > subscribing). > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Yahoo! Tax Center - online filing with TurboTax > > > http://taxes.yahoo.com/ > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).