Oracle 查Table 大小,筆數
SELECT OWNER,TABLE_NAME,NUM_ROWS,BLOCKS,BLOCKS*8096 as blockusebyte,AVG_ROW_LEN,AVG_ROW_LEN*NUM_ROWS as rowusebyte
FROM all_tables
WHERE owner<>'SYS' and owner<>'SYSTEM'
AND blocks is not null
ORDER BY NUM_ROWS DESC
Oracle 查Table 大小,筆數
SELECT OWNER,TABLE_NAME,NUM_ROWS,BLOCKS,BLOCKS*8096 as blockusebyte,AVG_ROW_LEN,AVG_ROW_LEN*NUM_ROWS as rowusebyte
FROM all_tables
WHERE owner<>'SYS' and owner<>'SYSTEM'
AND blocks is not null
ORDER BY NUM_ROWS DESC
1.增加主鍵
alter table TABLE_NAME add constraint KEY_NAME primary key (TABLE_COLUMN);
指定表空間
alter table TABLE_NAME add constraint KEY_NAME primary key (TABLE_COLUMN) using index tablespace TABLE_SPACE_NAME;
2.增加外鍵