Re: RE: omf and maintaining naming conventions
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 24 Feb 2004 16:07:04 -0500
i didnt notice that you can delete the datafile from with in oracle. I missed
it in the docs.
>
> From: Pete Sharman <peter.sharman@xxxxxxxxxx>
> Date: 2004/02/24 Tue PM 03:49:29 EST
> To: oracle-l@xxxxxxxxxxxxx
> CC: "Peter Ross. Sharman" <PETER.SHARMAN@xxxxxxxxxx>
> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Kirtikumar Deshpande
> Sent: Wednesday, February 25, 2004 6:52 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxxx> 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@xxxxxxx [mailto:ryan.gaffuri@xxxxxxx]
> > Sent: Tuesday, February 24, 2004 2:41 PM
> > To: oracle-l@xxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
