Hello, I have a basic understanding when it comes to administering Oracle DB and I am running into an issue that I think would be good to get a second opinion on.
We use Oracle Data Integrator 12c running on Oracle DB 12c and we have been encountering the following error:
ORA-01654: unable to extend index
I understand the issue relates to the amount of free tablespace and have resolved by adding an additional data file, but the original data file has AUTOEXTENSIBLE set to YES so I am confused as to why adding an additional data file is necessary.
Looking at the best practice docs from Oracle I am not seeing anything that appears to be related to this so was wondering if anyone else has recommendations on how best to manage.
Thank you!