Appl:01564-Oracle 01654 Error-Urgent Pls

[anandharaj]

Dear Friends,

We have the foll. environment

Database : Oracle 8.0.5.0.1 Enterprise
Application: Oracle Appln 11.0.3
OS: Win-Nt 4 / SP 5
------------------------------------------------------------
While posting the GL, we have the following Error in our ORACLE APPLICATION,

" APP01564: Oracle Error - 01654 in SUBMIT: others

Cause: SUBMIT: Others failed due to ORA-01654, Unable to extent index APPLSYS.FND_CONC_RELEASE_CLASSES_N1 by 93 in Tablespace APPLSYSD
----------------------------------------------------------
We have referred Oracle Manual for the error : 01654
It has given the following Tips:

Cause: Failed to allocate extent for index segment in tablespace.

Action: ALTER TABLESPACE ADD DATAFILE Statement to add one or more files to the specified tablespace.

------------------------------------------------------------
Since I am a junior DBA, Before starting the Action, I require further step by step procedures to solve this problem.

Please advice me

Thanks a lot

Anandharaj

[rotem_fo]

Hi,
The tablespace has reached its max extents, meaning it cannot allocate another extent within the datafile for the data you are trying to add.
You have 3 choices:
1) auto-extend the datafile, thus loosing control over the datafile because it will handle all extents automatically.
2) add a datafile to the tablespace. (use storage manager).
3) recalculate the tablespace and decide the extent numbers, its size etc..
you can read all about it in:
http://technet.oracle.com/deploy/ava...pdf/defrag.pdf