Re: trailing white spaces in datafile names (Linux)

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Mon, 23 Feb 2009 23:44:50 -0600
Message-ID: <vNLol.23426$ZP4.545_at_nlpi067.nbdc.sbc.com>



gareth_at_jamms.org wrote:
> On 23 Feb, 16:36, NetComrade <netcomradeNS..._at_bookexchange.net> wrote:
>> Did anyone ever have to fix an 'error' like that?
>>
>> They can easily be renamed in Oracle, but what to do on the OS?
>>
>> Thanks
>> .......
>> We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
>> We use RMAN and remote catalog for backups

>
> Spaces in filenames are thoroughly evil, if you ask me. Anyway,
> enclose the filename in quotes ("):

and perpetuated by MS because most pc users are too ignorant to know better - so they "fixed it" for them and really screwed it up for everyone else...

>
> $ mv "old filename with trailing space "
> new_filename_without_a_space
>
> HTH
>
> -g
Received on Mon Feb 23 2009 - 23:44:50 CST

Original text of this message