RE: omf and maintaining naming conventions

From: Koivu, Lisa <Lisa.Koivu_at_Cendant-TRG.com>
Date: Tue, 24 Feb 2004 14:43:41 -0500
Message-ID: <840C139B79E7CC4496B2594E9E35E967046C545D@floexmailbe2.ffci.com>

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

pointer to one location for our datafiles
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

Received on Tue Feb 24 2004 - 13:41:32 CST