# Using SQL to view partition info (toad for oracle)

**URL:** <https://forums.toadworld.com/t/using-sql-to-view-partition-info-toad-for-oracle/26307>\
**Category:** Toad for SQL Server\
**Created:** [August 15, 2013, 8:58am UTC](https://forums.toadworld.com/t/using-sql-to-view-partition-info-toad-for-oracle/26307 "2013-08-15T08:58:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ebay\_inc](https://avatars.discourse-cdn.com/v4/letter/e/e495f1/32.png) [@ebay\_inc](https://forums.toadworld.com/u/ebay_inc)\
**Post date:** [August 15, 2013, 8:58am UTC](https://forums.toadworld.com/t/using-sql-to-view-partition-info-toad-for-oracle/26307/1 "2013-08-15T08:58:14Z")

</div>

Hello All

New sql and oracle.

Trying to select my partition data from my table. but its not returning any rows

select  
\*  
from user\_tab\_partitions  
where table\_name = ‘Owner.my\_table’;

it will display the column headers but no rows of date.

But when i describe table i can see the partition rows of data.

Thanks

Jason

---

<div class="post-metadata">

**Author:** ![kay96](https://avatars.discourse-cdn.com/v4/letter/k/77aa72/32.png) [@kay96](https://forums.toadworld.com/u/kay96)\
**Post date:** [November 15, 2013, 12:29am UTC](https://forums.toadworld.com/t/using-sql-to-view-partition-info-toad-for-oracle/26307/2 "2013-11-15T00:29:16Z")

</div>

there is no table like Owner.my\_table