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 <wisernet100_at_yahoo.com> 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 <treegarden_at_yahoo.com> wrote:
> >
> > That's a great idea. Henceforth I'm going to do the same! Thanks.
> >
> >
> > --- Rachel Carmichael <wisernet100_at_yahoo.com> wrote:
> > > and, on a Unix box, I ALWAYS do an "fuser" before deleting a
> file.
> > > Just
> > > in case.
> > >
> > >
> > > --- Jonathan Gennick <listmail_at_gennick.com> 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:jonathan_at_gennick.com
> > > > http://Gennick.com * http://MichiganWaterfalls.com *
> > > > http://ValleySpur.com
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Jonathan Gennick
> > > > INET: listmail_at_gennick.com
> > > >
> > > > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: treegarden_at_yahoo.com
> >
> > 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: treegarden_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Fri Apr 05 2002 - 08:53:27 CST
