There are chances of
mistake in life and the same kind of mistakes can happen in the DBA life also. The
mistake on the production database is not advisable. J
But anyway, there are chances of adding special characters by mistake in the
data file name while adding the datafile to the tablespace. You can rename the
datafile using following steps.
Here in this example
I am adding one datafile with special character and new line character. SQL> alter tablespace SQCTST
add datafile '/u01/oradata/sqctst/sqctst@~! 08.dbf' size 2m;
SQL> select file_name,
bytes/1024/1024 from dba_data_files where tablespace_name='SQCTST'