When highlighting an object and executing the Segment Advisor, I get the message "No Script was produced for these tasks"
Unless the advisor has an action to take, the above message will be displayed.
Toad for Oracle provides an interface for using Oracle's OEM Segment Advisor
If you see a 'No script' in the Status column then you should scroll along to the 'Message' column for an explanationas to what action, if any, is being recommended. If you select all the result rows, you will find that Toad does not produce anything for rows that have 'No script' in the status column.
If all of the rows have 'No script' then no script will be produced at all
If there are recommendations in the message column then you should see some entries in the script e.g.
alter table "SUSAN"."AUDIT_LOG" enable row movement;
alter table "SUSAN"."AUDIT_LOG" shrink space COMPACT;
alter table "SUSAN"."AUDIT_LOG" shrink space;
For more information on Oracle's Segment Advisor:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBIEGGC
