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

Reply via email to