max extend db_files unalbe to Extend

[Former Member]

Dear All,

We are using Oracle 10.2.0.2 , SAP Ecc 6.0 ,OS : HP unix 11.23

Using Brtools I unable to extend the table space , Following error occurs :

ORA - 00059 unable to extend the tablespace PSAPBTABD ,

Please reply me procedure for increase the db_files ?

Regards,

Santosh

[Former Member · Accepted solution]

Execute below query:

sqlplus>show parameter spfile

If you get any parameter value (path), then you are using spfile, if no you have pfile.

Regards,

Nick Loy

[Former Member]

Hi Santosh,

Have a look at SAP notes 8812 and 398927.

Thanks,

Mahendra

[Former Member]

Just change the parameter value in init file and restart DB (If you are using pfile)

If you are using spfile then you have to follow the below steps:

1) Change the parameter value in init file

2) Shutdown database

3) Startup with pfile

4) Create spfile from pfile

Regards,

Nick Loy

[Former Member]

How to know I am using pfile or spsfile ?