Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: omf and maintaining naming conventions

Re: RE: omf and maintaining naming conventions

From: <ryan.gaffuri_at_cox.net>
Date: Tue, 24 Feb 2004 16:07:59 -0500
Message-Id: <20040224210759.TOEM25875.lakemtao07.cox.net@smtp.central.cox.net>


i agree. i just wanted the path set.
>
> From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
> Date: 2004/02/24 Tue PM 04:06:03 EST
> To: oracle-l_at_freelists.org
> Subject: RE: omf and maintaining naming conventions
>
> I believe you can rename OMFs.
> I just don't like those names with a mix of upper and lower case, the embedded tablespace name, if
> long, gets truncated. It's just a bit of pain using the file name when one has to recover the
> datafile. With our standard naming conventions it is pretty simple...
> ..... but now one can also argue how often one has to recover.. and the story continues.. :)
> So it depends..
> However, it is great feature for building test/throw away databases, particularly when playing
> around with new releases and such..
>
> - Kirti
>
> --- Pete Sharman <peter.sharman_at_oracle.com> wrote:
> > Um, yes, I suppose so, but why would you want to? The whole point of OMF is around lowering the
> > management requirements, and renaming the files just ups the management cost again.
> >
> > I haven't actually tried renaming an OMF file, so it may not even work.
> >
> > Pete
> >
> > "Controlling developers is like herding cats."
> >
> > Kevin Loney, Oracle DBA Handbook
> >
> > "Oh no, it's not. It's much harder than that!"
> >
> > Bruce Pihlamae, long-term Oracle DBA
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> > Kirtikumar Deshpande
> > Sent: Wednesday, February 25, 2004 6:52 AM
> > To: oracle-l_at_freelists.org
> > Subject: RE: omf and maintaining naming conventions
> >
> > Ah.. but again, one can always rename those... Right?
> >
> > The 'drop...' does work. With OMF and non-OMF files.
> >
> > - Kirti
> >
> > --- "Koivu, Lisa" <Lisa.Koivu_at_Cendant-TRG.com> wrote:
> > > No. OMF does not let you name datafiles. If you read the
> > > documentation, it states that it assigns a guaranteed unique name to the
> > > datafile.
> > >
> > > Does 'drop tablespace including contents and datafiles' not work? I use
> > > OMF but I'm beginning to think it's a pain in the a$$.
> > >
> > > -----Original Message-----
> > > From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
> > > Sent: Tuesday, February 24, 2004 2:41 PM
> > > To: oracle-l_at_freelists.org
> > > Subject: omf and maintaining naming conventions
> > >
> > > We have strict naming conventions for our datafiles. I want to use OMF
> > > for two reasons
> > >
> > > 1. pointer to one location for our datafiles
> > > 2. so when I drop tablespaces, the OS file gets dropped.
> > >
> > > Im hoping to be able to do this, but its not using the
> > > db_file_create_dest parameter
> > >
> > > create tablespace mytablespace 'mytablespace.dbf' size 5m;
> > >
> > > anyway to do this?
> > >
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> > >
> > > "The sender believes that this E-Mail and any attachments were free of any virus, worm, Trojan
> > > horse, and/or malicious code when sent. This message and its attachments could have been
> > > infected during transmission. By reading the message and opening any attachments, the
> > recipient
> > > accepts full responsibility for taking proactive and remedial action about viruses and other
> > > defects. The sender's business entity is not liable for any loss or damage arising in any way
> > > from this message or its attachments."
> > >
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Mail SpamGuard - Read only the mail you want.
> > http://antispam.yahoo.com/tools
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Feb 24 2004 - 15:04:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US