This content has been marked as final. Show 4 replies
You have specified a schema of 'DATA' and a null table name. You probably meant to use NULL for the schema to use the current schema.
select * from table (dbms_stats.DIFF_TABLE_STATS_IN_HISTORY ('DATA','',trunc(sysdate-2)));
See the PL/SQL Packages and Types doc
This function can be used to compare statistics for a table from two timestamps in past and compare the statistics as of that timestamps.
Table 127-22 DIFF_TABLE_STATS_IN_HISTORY Procedure Parameters
Owner of the table. Specify NULL for current schema.
Table for which statistics are to be compared
First timestamp 1
Second timestamp 2
The function reports difference in statistics only if it exceeds this limit. The default value is 10.