ORA-1654 <-> Unable to extend index
We have an oracle apps server and we started experiencing ORA-1654 errors. After digging through log files we found an error: ORA-1654: unable to extend index JTF.JTF_IH_ACTIVITIES_N6 by 16 in tablespace APPS_TS_TX_IDX.
From what I can figure we need to add a datafile to our system. We currently have 4 datafiles that are 4Gb each. Is this the correct solution? If so what is the safest way to do this. Can I copy the 4 DB files to an alternate location and restore that way if the adding file doesn't work or what is the best practice for this type of action? Thanks