Toad World® Forums

Using SQL to view partition info (toad for oracle)

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

there is no table like Owner.my_table