Database Tuning (MOSC)

MOSC Banner

Extended stats

edited Dec 3, 2019 5:31AM in Database Tuning (MOSC) 1 commentAnswered

Hi,

I'm trying to create extended stats as below and unable to do it when sum is used for both the statements,version 11203

select DBMS_STATS.CREATE_EXTENDED_STATS('USER','ACCTG_LN_PC','(sum(amount),sum(amount_base),sum(resource_quantity))') from dual;

exec dbms_stats.gather_table_stats('USER','ACCTG_LN_PC', method_opt =>'for all columns size skewonly for columns (sum(AMOUNT))');

*

ERROR at line 1:

ORA-20001: Error when processing extension -  group function is not allowed

Thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center