Xref: alice comp.databases.oracle.server:48341 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Need help renaming datafile with in name. Date: Wed, 5 May 1999 19:55:18 +0100 Message-ID: <925930665.24704.1.nnrp-04.9e984b29@news.demon.co.uk> References: <7gq0s3$ude$1@nnrp1.dejanews.com> X-Trace: news.demon.co.uk 925930665 nnrp-04:24704 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 30 You could try using dbms_sql to execute the Alter database, creating the necessary string using ..... || chr(13) || ..... -- Jonathan Lewis Yet another Oracle-related web site: www.jlcomp.demon.co.uk kcary@my-dejanews.com wrote in message <7gq0s3$ude$1@nnrp1.dejanews.com>... >Unfortunately, in creating the tablespace for our Enterprise manager >repository we hit a return before entering the close quote and contined the >create command on the next line in SVRMGR. This created a datafile whose name >was, in effect, > > oem_data.dbf^M > >and this is reflected in file system listings, OEM listings of datafiles, etc. > >A simple trick to rename the file in the system (AIX), however, we want to >figure out how to do this within Oracle (7.3.2). Unfortunately, the create >and rename function seem asymetric--you can create a datafile with the >but can't rename one that has a in it. The listing at the bottom of this >message shows our rename attempt, which is structured the same way as the >create statement.