Current Position:Home > Viewing existing partitions

Viewing existing partitions

Update:11-30Source: network consolidation
Advertisement
Hi ,
How can I view whether partitions exist for a table and what is the range and what is the type . I mean how can I view the details of a partition of an existing table.
Regards,
Rahul.

The Best Answer

Advertisement
Check USER/ALL/DBA_TAB_PARTITIONS
http://download.oracle.com/docs/cd/B10501_01/server.920/a96536/ch2147.htm#1303158

Recommended Content

Database error: [Table 'ac_posts' is marked as crashed and should be repaired]

SELECT * FROM ac_posts WHERE `ID` IN (4996174,4311211,2604660,4783039,4032789,2326576,1097855,1566889,1300940,4583872,468285,4335891,2639542,4333494,2519005,4915210,2171463,3150565,3644333,1574231,1656880,3262997,1786041,1578276,2705008,1419071,2241216,1200269,5079006,1867058,4123605) LIMIT 15;