error while running statspack -"unable to exetend index"

[lhugh]

Does anybody know what this means?

Thanks

----------------------------------------

SQL> variable snap number;
SQL> begin
2 :snap := statspack.snap;
3 end;
4 /
begin
*
ERROR at line 1:
ORA-01654: unable to extend index PERFSTAT.STATS$SYSSTAT_PK by 256 in
tablespace TOOLS
ORA-06512: at "PERFSTAT.STATSPACK", line 2090
ORA-06512: at line 2

 

[carp]

It appears your TOOLS tablespace is out of freespace. You must increase the size of the tablespace (or remove/reorganize some objects within that tablespace) before you can proceed.

Elbert, CO
1107 MST

 

[lhugh]

thank you