Tips: Add to Google | Oracle DUL? | AUL License | WebChart | asyncdata | ociuldr

Contact: anysql©yahoo.com/anysql©126.com, MSN: loufangxin©msn.com, AIM: loufangxin

How to move Oracle context index to another tablespace?

    We cannot use following command to move Oracle context index to another tablespace, because it's a special kind of index. ALTER INDEX ... REBUILD TABLESPACE CTXDATA;     You need create new storage setting or modify existing storage...

Tags:

Posted on September 26, 2007 12:59 PM

How to install or uninstall (remove) Context on Oracle 9i/10g?

    The steps of context install on Oracle 10g. 1, create tablespace drsys 2, run @?/ctx/admin/catctx.sql ctxsys drsys temp01 nolock 3, run @?/ctx/admin/defaults/drdefus.sql 4, grant execute on ctxsys.ctx_ddl to public     The steps of context uninstall (remove) on...

Tags:

Posted on September 25, 2007 5:42 PM