<div>
any better like this:<br />
<br />
execute DBMS_DDL.analyze_object('T<wbr />ABLE','EMP<wbr />LOYEES');<br />
<br />

</div>


any better like this:

execute DBMS_DDL.analyze_object('TABLE','EMPLOYEES');



<div>
I do not know how can I get privilege to execute that !! <br />
please explain !!<br />

</div>


I do not know how can I get privilege to execute that !!
please explain !!


<div>
I think master sujith solved my problem!!<br />
<br />
Thanks for your excuse !!<br />
<br />
bye the way if you have kindness please tell me how can I grant previlege for excuting<br />
'analyze object' &nbsp;by any user or specify user. however it's not neccessary yet because you resolved <br />
my damn problem.<br />
<br />
Thanks once again !!
</div>


I think master sujith solved my problem!!

Thanks for your excuse !!

bye the way if you have kindness please tell me how can I grant previlege for excuting
'analyze object'  by any user or specify user. however it's not neccessary yet because you resolved
my damn problem.

Thanks once again !!

<div>
<div class="content wysiwyg-content">
OPERATING SYSTEM : WINDOWSXP SERVICE PACK 2<br />
PRODUCT : ORACLE 9.X RE. 1.0.1.0.1.1<br />
<br />
OUT CRY : SOLVE THIS ERROR PLEASE<br />
<br />
SQL&gt; connect hr/hr<br />
Connected.<br />
SQL&gt; execute analyze_object('TABLE','EM<wbr />PLOYEES');<wbr /><br />
BEGIN analyze_object('TABLE','EM<wbr />PLOYEES');<wbr /> END;<br />
<br />
&nbsp; &nbsp; &nbsp; *<br />
ERROR at line 1:<br />
ORA-06550: line 1, column 7:<br />
PLS-00201: identifier 'ANALYZE_OBJECT' must be declared<br />
ORA-06550: line 1, column 7:<br />
PL/SQL: Statement ignored<br />

</div>
</div>


OPERATING SYSTEM : WINDOWSXP SERVICE PACK 2
PRODUCT : ORACLE 9.X RE. 1.0.1.0.1.1

OUT CRY : SOLVE THIS ERROR PLEASE

SQL> connect hr/hr
Connected.
SQL> execute analyze_object('TABLE','EMPLOYEES');
BEGIN analyze_object('TABLE','EMPLOYEES'); END;

      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'ANALYZE_OBJECT' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


ANALYZE OBJECT PROBLEM !!

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.