-
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
-
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
