Rebuilding Multiple Objects

[Peter Kilpatrick]

Hi
 
Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?
 
If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?
 
Cheers
 
Peter

[Bert Scalzo]

Note that Toad 9.6 came out before Oracle 11g R2 (currently only supported version of Oracle not requiring extended support) and so if you're on 11gR2 then you're in grey zone and unsupported ....

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Peter Kilpatrick
Sent: Tuesday, February 12, 2013 9:11 AM
To: ***@yahoogroups.com
Subject: [toad] Rebuilding Multiple Objects


Hi

Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?

If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?

Cheers

Peter

[peterk27]

Yeah I know, but Toad 9.6 has the great option of being able to select multiple objects from the screen to rebuild. With Toad 11 I have to load the objects and then select them one by one to do the rebuild.

Cheers

Peter

Post by Bert Scalzo
Note that Toad 9.6 came out before Oracle 11g R2 (currently only supported version of Oracle not requiring extended support) and so if you're on 11gR2 then you're in grey zone and unsupported ....
Sent: Tuesday, February 12, 2013 9:11 AM
Subject: [toad] Rebuilding Multiple Objects
Hi
Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?
If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?
Cheers
Peter

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[John Dorlon]

Database -> Optimize -> Rebuild Multiple Objects.

There are various ways to load the screen with tables (by schema, tablespace, or matching a 'like' pattern), then you can pick the ones you want to rebuild



From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Peter Kilpatrick
Sent: Tuesday, February 12, 2013 9:11 AM
To: ***@yahoogroups.com
Subject: [toad] Rebuilding Multiple Objects


Hi

Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?

If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?

Cheers

Peter

[peterk27]

Yup, I can load the objects to rebuild, but I am wanting to rebuild 500 indexes, how can I select all 500 without having to select one by one?

Cheers

Peter

Post by John Dorlon
Database -> Optimize -> Rebuild Multiple Objects.
There are various ways to load the screen with tables (by schema, tablespace, or matching a 'like' pattern), then you can pick the ones you want to rebuild
Sent: Tuesday, February 12, 2013 9:11 AM
Subject: [toad] Rebuilding Multiple Objects
Hi
Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?
If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?
Cheers
Peter

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[John Dorlon]

You can multiselect the ones you want, then rt-click the "include" column header, then choose "check selected". Anytime you see a checkbox in a grid in Toad, that popup menu will exist on the column header.

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of peterk27
Sent: Tuesday, February 12, 2013 11:25 AM
To: ***@yahoogroups.com
Subject: [toad] Re: Rebuilding Multiple Objects



Yup, I can load the objects to rebuild, but I am wanting to rebuild 500 indexes, how can I select all 500 without having to select one by one?

Cheers

Peter

Post by John Dorlon
Database -> Optimize -> Rebuild Multiple Objects.
There are various ways to load the screen with tables (by schema, tablespace, or matching a 'like' pattern), then you can pick the ones you want to rebuild
Sent: Tuesday, February 12, 2013 9:11 AM
Subject: [toad] Rebuilding Multiple Objects
Hi
Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?
If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?
Cheers
Peter

[peterk27]

Thank you, thank you, thank you. You have no idea how much easier you have made my life. I have been searching for this for a long time now (ever since Toad 10, and have kept Toad 9.6 on my desk top just for this feature. When my desk top failed on the week end and needed a complete reimage, I found that I did not have a copy of Toad 9.6 and thus became very worried / frustrated.

Cheers

Peter

Post by John Dorlon
You can multiselect the ones you want, then rt-click the "include" column header, then choose "check selected". Anytime you see a checkbox in a grid in Toad, that popup menu will exist on the column header.
Sent: Tuesday, February 12, 2013 11:25 AM
Subject: [toad] Re: Rebuilding Multiple Objects
Yup, I can load the objects to rebuild, but I am wanting to rebuild 500 indexes, how can I select all 500 without having to select one by one?
Cheers
Peter

Post by John Dorlon
Database -> Optimize -> Rebuild Multiple Objects.
There are various ways to load the screen with tables (by schema, tablespace, or matching a 'like' pattern), then you can pick the ones you want to rebuild
Sent: Tuesday, February 12, 2013 9:11 AM
Subject: [toad] Rebuilding Multiple Objects
Hi
Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?
If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?
Cheers
Peter

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)

<*> To change settings via email:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[John Dorlon]

Hmmm...if you multiselect and rt-click the indexes from the SB, do you not have a 'rebuild' option? I see that in the current beta and it's been there for a while.

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of peterk27
Sent: Tuesday, February 12, 2013 11:25 AM
To: ***@yahoogroups.com
Subject: [toad] Re: Rebuilding Multiple Objects



Yup, I can load the objects to rebuild, but I am wanting to rebuild 500 indexes, how can I select all 500 without having to select one by one?

Cheers

Peter

Post by John Dorlon
Database -> Optimize -> Rebuild Multiple Objects.
There are various ways to load the screen with tables (by schema, tablespace, or matching a 'like' pattern), then you can pick the ones you want to rebuild
Sent: Tuesday, February 12, 2013 9:11 AM
Subject: [toad] Rebuilding Multiple Objects
Hi
Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?
If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?
Cheers
Peter

[Donna Buskirk]

Hi there,
Not sure what version you're currently using, but in v11.6 Help, here's the info you'll need:
Help | Contents | Work with Objects | Rebuild Objects
[cid:***@01CE090A.EACEAFE0]


From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Peter Kilpatrick
Sent: February 12, 2013 10:11 AM
To: ***@yahoogroups.com
Subject: [toad] Rebuilding Multiple Objects




Hi

Way back in Toad 9.6 there was a right click menu item to select all highlighted objects for rebuilding. I have not been able to find this option in the recent Toad version - can some one tell me where this option was moved to?

If it was taken out, could some one please point me to a Toad 9.6 download so that I can install that version?

Cheers

Peter