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

Home -> Community -> Usenet -> c.d.o.misc -> How do I view what partition names are?

How do I view what partition names are?

From: RK <rekaben_at_yahoo.com>
Date: 17 Jan 2005 11:19:19 -0800
Message-ID: <239f1935.0501171119.40a914a1@posting.google.com> 





Hi,



I am not the DBA, and I can not find him anywhere. But I know the big
tables are partitioned. My question is that how to find out what the
partition names the DBA is using for partitioning the tables.
Something like the following codes to find what tablenames are:



select table_name from all_tables;



Which table can I look for this info? Any help?



Thanks.



RK
Received on Mon Jan 17 2005 - 13:19:19 CST












Original text of this message













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