column owner format a16 column object_name format a36 column start_day format a11 column block_increase format 9999999999 select
Script:查找表或索引增长的历史信息
原创maclean_007 ©著作权
文章标签 HISTORY space SIZE SEGMENT AWR Oracle脚本script 文章分类 Oracle 数据库
-
Script:列出没有主键或唯一索引的表
以下脚本可以用于列出数据库中没有主键的表,已排除了系统schema:REM List tables with no primary keySELECT owner, table_name FROM dba_tables WHERE 1 = 1 AND owner NOT IN ('SYS', 'SYSTEM',
key index primary unique constraint Oracle脚本script