error while taking a copy of system statistics
Hi ,
I am trying to make copy of current system statistics so I am trying to take current system statistics to a table but I am getting a following error. Please suggest how to execute these procedures.
SQL> declare
system_statistics varchar2(30000);
begin
DBMS_STATS.GATHER_SYSTEM_STATS (
stattab => system_statistics,
statid =>1
);
end;
/ 2 3 4 5 6 7 8 9
declare
*
ERROR at line 1:
ORA-20001: 1 is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 1975
ORA-06512: at "SYS.DBMS_STATS", line 1991
ORA-06512: at "SYS.DBMS_STATS", line 20184
ORA-06512: at line 4
Thanks
Rakesh K