Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sys.dual? index?

Re: sys.dual? index?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Mar 2006 14:31:58 -0800
Message-ID: <1142116318.498951.157400@i40g2000cwc.googlegroups.com> 





The real question is why the *&^% you would create an index on sys.dual
to begin with.  Rule 1 in Oracle is that you NEVER modify a SYS owned
table except under the direction of Oracle support.



Wjat happens if you remove the double quotes from around the DDL
command: drop index i_dual_1?



HTH -- Mark D Powell --
Received on Sat Mar 11 2006 - 16:31:58 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US