摘要:
1.查看一个表所占的空间大小:SELECT bytes/1024/1024 ||'MB' TABLE_SIZE ,u.* FROM USER_SEGMENTS U WHERE U.SEGMENT_NAME='JK_TEST';2.查看一个表空间所占的实际大小:SELECT SUM(BYTES) / 阅读全文
摘要:
时间范围分区拆分create table emp (id number(6) not null,hire_date date not null)partition by range(hire_date)(partition p_1998 values less than (to_date('1998 阅读全文