Using SQL to view partition info (toad for oracle)

Toad for SQL Server
1

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

2

there is no table like Owner.my_table