DBA Tools

Recover the table's index structure information.

    AUL just focus on the data recovery, it does not generate the SQL of creating the indexes, but we can recover them. Just recover some kernel table's data and load them into new database, then run query to...

Posted on March 20, 2008 2:42 PM

Describe tables with indexes structure information

    When describe a talbe to get the structure information, I also hope to display the indexes information. In AnySQL, I wrote the DESCRIBE command with this feature. It really save me a lot of time to write SQLs...

Posted on December 20, 2007 10:09 PM

Compare index structure difference between tables

    I will introduce you how to compare index structure between tables with the compare any column utility (Overview / Download). I fixed the table structure difference found in previous case, and create the following indexes for demo. CREATE...

Posted on October 23, 2007 5:44 PM

Performance issue by OR operation because filter at table level.

    I create a composite index (DEPTNO and ENAME columns) on table SCOTT.EMP. Then I run the following SQL. SQL> SELECT /*+ first_rows no_expand */ * FROM EMP    2 WHERE deptNO=10 AND (ENAME IS NULL OR ENAME >...

Posted on October 11, 2007 10:00 AM

Compute statistics when creating index will analyze table in Oracle 9i

    I have a table named "T_OBJECTS" and one index on it named "T_OBJECTS_IX1". They are not analyzed now: TABLE_NAME       NUM_ROWS LAST_ANALYZED -------------- ---------- --------------- T_OBJECTS T_OBJECTS_IX1     Now I receive a task to create a second index...

Posted on October 10, 2007 5:15 PM

How to handle resource busy (ORA-00054) error in Oracle?

    When creating or rebuilding indexes on hot tables, we will use parallel option to make the it quickly, but please remember to disable the parallel after creating or rebuilding, else it will make the relative SQL run in...

Posted on October 10, 2007 5:10 PM

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...

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...

Posted on September 25, 2007 5:42 PM