Monday, 15 July 2013

oracle - ORA-01537. i want to search where the file is included -



oracle - ORA-01537. i want to search where the file is included -

sql> alter tablespace java add together datafile 'd:/programming/java.dbf'; * error @ line 1: ora-01537: cannot add together file 'd:/programming/java.dbf' - file part of database sql> select tablespace_name,file_name,status dba_data_files 2 file_name='%java.dbf'; no rows selected.

i want know statement searching file included.

use like instead of =:

select tablespace_name, file_name,status dba_data_files upper(file_name) '%java.dbf';

oracle

No comments:

Post a Comment