Analyzing Individual Partitions in Toad 12

Toad for Oracle
1

Hi

In Toad 10.1 there was a tick box option to select individual table partitions to analyze but I can not find it (or an equivalent) in Toad 12.1.

In Toad 10 I’d select a partitoned table, click on the Analyze Table icon, and select the Options tab. There was a tick box at the top of this tab called ‘Load All Partitions of Partitioned Tables/Indexes’, which would load each partition separately in the Tables tab.

Does this option exist in Toad 12? If so, how to I ‘switch it on’?

Thanks

Paul

2

Hi Paul,

In the “Load my tables” dropdown button, check out the last item called “Partitioned table options”

Thanks,

Brad

From: PaulR [mailto:bounce-PaulR@toadworld.com]

Sent: Monday, March 10, 2014 4:57 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Analyzing Individual Partitions in Toad 12

Analyzing Individual Partitions in Toad 12

Thread created by PaulR

Hi

In Toad 10.1 there was a tick box option to select individual table partitions to analyze but I can not find it (or an equivalent) in Toad 12.1.

In Toad 10 I’d select a partitoned table, click on the Analyze Table icon, and select the Options tab. There was a tick box at the top of this tab called ‘Load All Partitions of Partitioned
Tables/Indexes’, which would load each partition separately in the Tables tab.

Does this option exist in Toad 12? If so, how to I ‘switch it on’?

Thanks

Paul

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

3

Hi Brad

Perfect - thanks very much.

Paul