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: how to find unused table /columns in a database

Re: how to find unused table /columns in a database

From: <sybrandb_at_yahoo.com>
Date: 16 Mar 2006 01:52:45 -0800
Message-ID: <1142502765.594546.321630@e56g2000cwe.googlegroups.com> 





There isn't.


Probably columns containing only NULLS are unused, but you would need
to find them manually.


Oracle assumes databases are designed properly, not hacked together. It
also can't read your mind so it can't tell whether these columns are
really unused.


--
Sybrand Bakker
Senior Oracle DBA


Received on Thu Mar 16 2006 - 03:52:45 CST












Original text of this message













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