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
-----------------------------------------------------------------
Received on Tue Feb 24 2004 - 14:46:54 CST
