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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Looking for a Script to list tables,its indexes and sizing info

Re: Looking for a Script to list tables,its indexes and sizing info

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Fri, 27 Jan 2006 14:31:03 -0500
Message-ID: <BAY103-DAV17A33578ACB44C5B7B1A85A6140@phx.gbl>


Do a select * from dict where table_name like 'DBA%' - you can replace the wild card search with the names of your column headers. That should give you some tables where to find your information. This looks like a homework question. I say this because the formatting of your output looks too nice to be a question of curiousity.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 27 2006 - 13:31:03 CST

Original text of this message

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