|Segment advisor problem [message #218701]
||Fri, 09 February 2007 06:53
Registered: June 2006
Can anybody please tell me what is worng with the following code or what do I need to do to get dbms_advisor work?|
dbms_output.put_line('Number is '|| task_id);
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at line 14
My objective is to collect segment advices for the above mentioned table.
Based on the task_id I will query dba_advisor_findings to make sure if any shrinkage is required for the above table.
Thanks and Regards
[Updated on: Fri, 09 February 2007 06:58]
Report message to a moderator