1、表超过254列,数据会被放到不同的block中
2、rowid组成:data object number, relative file number,block number,row number
3、structure of a row: row heaer {col length col value}*
4、create global temprary table tmp1 on commit {preserve|delete} rows as select * from t where 1=0; (session级别,transaction级别)
5、set pctfree & pctused: pctfree=(average row size-initial row size)*100/average row size
6、manually allocating extents: alter table t allocate extent
把extents分散到不同文件
批量导入数据时提高速度
7、看表详细信息:
desc t
select dbms_metadata.get_ddl('TABLE','T') from dual;
8、避免行迁移 链接:
alter table t move tablespace ..
create table m as select * from t d -> drop t -> rename m to t
truncate table t
9、drop a column 避免充满undo:alter table t drop column name cascade constraints checkpoint 1000
10、同时删除多列:
alter table t set unused column name cascade constraints;
.............
alter table t drop unused column name checkpoint 1000 unused标示后可以同时删除多列