Home » SQL & PL/SQL » SQL & PL/SQL » Partitioned table information (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production)
Partitioned table information [message #574228] Tue, 08 January 2013 03:33 Go to next message
saipradyumn
Messages: 178
Registered: October 2011
Location: Hyderabad
Senior Member
Hi All,

Could please tell me how to know weather table is partitioned or not ?
Is there any data dictionary view to know the information about the Partitioned type,keys on table ?

Thanks
SaiPradyumn
Re: Partitioned table information [message #574234 is a reply to message #574228] Tue, 08 January 2013 03:41 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

Below are data dictionary tables...
all_tab_partitions,user_tab_partitions,dba_tab_partitions
Re: Partitioned table information [message #574235 is a reply to message #574228] Tue, 08 January 2013 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 58521
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ DBA_TABLES.PARTITIONED
2/ select * from dict where lower(comment) like '%partition%';

All catalog views are described in Database Reference.

Regards
Michel
Re: Partitioned table information [message #574236 is a reply to message #574234] Tue, 08 January 2013 03:44 Go to previous messageGo to next message
saipradyumn
Messages: 178
Registered: October 2011
Location: Hyderabad
Senior Member

Thanks Murali

Re: Partitioned table information [message #574238 is a reply to message #574235] Tue, 08 January 2013 03:45 Go to previous message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

and also giving more information for this table
all_part_tables


Useful site..

http://docs.oracle.com/cd/E11882_01/server.11a2/e25523/part_admin005.htm

[Updated on: Tue, 08 January 2013 03:57] by Moderator

Report message to a moderator

Previous Topic: varchar2 data change 'mmyyyy' to 'yyyymm'
Next Topic: How to run query between 2 schemas
Goto Forum:
  


Current Time: Wed Jul 23 21:34:57 CDT 2014

Total time taken to generate the page: 0.11018 seconds