-- 查询到表空间的详细信息
set wrap off
set linesize 1000
spool e:\qin_daily\查询表空间的详细信息_script003
SELECT TABLESPACE_NAME,
INITIAL_EXTENT,
NEXT_EXTENT,
MIN_EXTENTS,
MAX_EXTENTS,
PCT_INCREASE,
MIN_EXTLEN,
STATUS,
CONTENTS,
LOGGING,
EXTENT_MANAGEMENT, -- Columns not available in v8.0.x
ALLOCATION_TYPE, -- Remove these columns if running
PLUGGED_IN, -- against a v8.0.x database
SEGMENT_SPACE_MANAGEMENT --use only in v9.2.x or later
FROM DBA_TABLESPACES
ORDER BY TABLESPACE_NAME;
spool off
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12330444/viewspace-434589/ ，如需转载，请注明出处，否则将追究法律责任。
