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