Skip to Content
0
Former Member
Jan 02, 2008 at 07:00 PM

renaming oracle datafiles at the unix level

91 Views

I have noticed that some of the datafile under /oracle/DV1/sapdata2/ have some strange characters in them

Grrr - DBAs that don't know brtools.....

for example:

drwxr-xr-x 2 oradv1 dba 256 Nov 02 23:22 sr3\177_2

and it shows as sr3_2 unless you use ls -lb which shows the above:

Now can I simply stop the DB and cp -rp sr3\177_2 to sr3_2?

I can actually cp -rp sr3\177_2 to sr3_X and then copy sr3_X to sr3_2 or an mv.

So can I do this without screwing up Oracle and SAP?

What should I do as the \177 characters should not be there?

Thanks Mikie