喜欢就来多看看
New feathers(Ora9i)
上一篇 /
下一篇 2006-08-10 00:00:00
/ 个人分类:回味&引申
sga/spfile/db_block_size(db_nk_cache_size).but keep/recycle define for default cache/pga(workarea_size_policy)/cursor_sharing/case/merge
dataguard/logminer/resumable statements/external tables/list partition/rman/rac/[un]quiesce database/bitmap index
alter table/index ** rename to *(10g can rename tablespace)
alter table ** rename column * to *
alter table ** rename constraint * to *
transport tablespace at different ora9i(from 4k->8k)
transport tablespace at different oracle(from ora8i->ora9i)
above two must have same character set
alter index * [no]monitoring usage =see if index is being used
alter index * rebuild compute statistics online<nologging>;
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: