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
-----------------------------------------------------------------
Received on Tue Feb 24 2004 - 15:03:17 CST
