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