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:04 -0500
Message-Id: <20040224210704.TVYJ7047.lakemtao05.cox.net@smtp.central.cox.net>


i didnt notice that you can delete the datafile from with in oracle. I missed it in the docs.
>
> From: Pete Sharman <peter.sharman_at_oracle.com>
> Date: 2004/02/24 Tue PM 03:49:29 EST
> To: oracle-l_at_freelists.org
> CC: "Peter Ross. Sharman" <PETER.SHARMAN_at_oracle.com>
> Subject: RE: omf and maintaining naming conventions
>
> 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
> -----------------------------------------------------------------
>



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:10 CST

Original text of this message

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