Hello,

The system is responding with the ORA-00942 error message when I ran the following code. Please help me..

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

DECLARE
Tname varchar2(30);
CURSOR C1 IS SELECT table_name FROM dba_tables where chain_cnt > 0;

BEGIN
Open C1;
Loop
Fetch C1 into Tname;
dbms_output.put_line( 'Analying the table: ' || Tname );
execute immediate 'analyze table Tname list chained rows';
EXIT WHEN C1%NOTFOUND;
End Loop;
CLOSE C1;
End;
/

---------------------------------------------------
Here is the error message:

ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 10

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

Thanks,
Seenu