Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

collecting the table stats

3340203Nov 2 2016 — edited Nov 6 2016

Hello ,

I am at beginner level in oracle ..

when i tried to collect the table stas i got an error..

following is the code:

BEGIN

DBMS_STATS.GATHER_TABLE_STATS (

ownname => 'RTDMASL',

tabname => 'CMPGN_ACCT_1230',

estimate_percent =>DBMS_STATS.AUTO_SAMPLE_SIZE,

degree => null,

granularity =>'AUTO',

no_invalidate => DBMS_STATS.AUTO_INVALIDATE

);

end;

following is the error message i got:

Error report -

ORA-06550: line 4, column 22:

PLS-00357: Table,View Or Sequence reference 'CMPGN_ACCT_0402' not allowed in this context

ORA-06550: line 2, column 1:

PL/SQL: Statement ignored

06550. 00000 - "line %s, column %s:\n%s"

*Cause: Usually a PL/SQL compilation error.

*Action:

anonymous block completed

Error starting at line : 3 in command -

tabname => 'CMPGN_ACCT_0402',

Error report -

Unknown Command

anonymous block completed

please help me with this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2016

Added on Nov 2 2016

#general-database-discussions

8 comments

1,349 views