Tag Archives: datafile

获取表空间是否可自动扩展的SQL

好长时间没写SQL了,今天看到同事在使用一个检查表空间是否可自动扩展的SQL,不但效率不高,而且非常的累赘,忍不住自己写了一个。 原始SQL如下: SQL> SELECT DISTINCT tablespace_name, autoextensible 2 FROM DBA_DATA_FILES 3 WHERE autoextensible = ‘YES’ 4 UNION 5 SELECT DISTINCT tablespace_name, autoextensible 6 FROM DBA_DATA_FILES 7 WHERE autoextensible = ‘NO’ 8 AND tablespace_name NOT IN 9 (SELECT DISTINCT tablespace_name 10 … Continue reading

Posted in ORACLE | Tagged , , | Leave a comment