Database Administration (MOSC)

MOSC Banner

Unknown character in a database datafile name

edited Mar 20, 2011 9:24AM in Database Administration (MOSC) 14 commentsAnswered ✓
Hi Everyone,
I found that one of our datafile name seems to contain an unknown character.
Our database is 10.2.0.4 on HPUX.

I run this query and got the following output
  1* select file_id,'XXXX'||nvl(substr(file_name,1,90),'yyyy')||'XXXX' from dba_data_files
SQL> /
         1 XXXX/u01/oradata/clmdev/system01.dbfXXXX                                                                                                  
         2 XXXX/u01/oradata/clmdev/undotbs01.dbfXXXX                                                                                                 
         3 XXXX/u01/oradata/clmdev/sysaux.dbfXXXX                                                                                                    
         4 XXXX/u01/oradata/clmdev/RT_DATA_PROD_01.dbf                                                                                               
           XXXX                                                                                                                                      
                                                                                                                                                     
         5 XXXX/u01/oradata/clmdev/RT_INDX_PROD_01.dbfXXXX 
When I check the length of the filename,I got this:
SQL> select length(file_name) from dba_data_files where file_id in (4,5);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center