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 > -- > 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).
