-
Error in DBMS.CREATE_STATS_TABLE
Hi,
I am running Oracle 8.1.7.2
I want to be able to preserve the current statistics prior to a major patch release for my application.
I get the following error when I want do create the table to store the statistics.
Command is:
SQL> execute SYS.DBMS_STATS.CREATE_STATS_TABLE (OWNNAME=> 'MYNAME', STATTAB=> 'MYNAME_STATS_TAB');
Error is:
BEGIN SYS.DBMS_STATS.CREATE_STATS_TABLE (OWNNAME=> 'MYNAME', STATTAB=> 'MYNAME_STATS_TAB'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 22:
PLS-00302: component 'CREATE_STATS_TABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Is there something I can do to 'declare' this component, or is this functionality not available in 8.1.7.2?
Thanks in advance for your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|