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 -----------------------------------------------------------------