Oracle 11g - Statspack installation issue.
1) Created a tablespace and named it as TBS2.
SQL> create tablespace TBS2
2 datafile 'C:\app\test\admin\dba\Datafile\data1.dbf'
3 size 100m;
create tablespace TBS2
2)Executed the spcreate.sql script to create statspack report.
SQL> @C:\app\test\product\11.1.0\db_1\RDBMS\ADMIN\spcreate.sql
3)PERFSTAT user password : perfstat
4)Default tabelspace name to store statspack report : TBS2
5) Enter the value of Temp tabelspace : TEMP
6) Statspack report started generating.
7) The report failed due to following reason.
create table STATS$FILE_HISTOGRAM
*
ERROR at line 1:
ORA-01659: unable to allocate MINEXTENTS beyond 7 in tablespace TBS2.
May i know what is the reason for the failure ?