喜欢就来多看看

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:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2009-01-09  
    123
45678910
11121314151617
18192021222324
25262728293031

数据统计

  • 访问量: 12315
  • 日志数: 1129
  • 图片数: 1
  • 书签数: 1
  • 建立时间: 2007-12-13
  • 更新时间: 2008-06-02

RSS订阅

Open Toolbar