Our customer is noticing ORA-01691 in their SYSAUX tablespace. Our customer's dba says it is causing due to data for LOB fields of our tables are getting stored in SYSAUX. Initially all the tables are created in the user tablespace. If the user tablespace becomes full, does Oracle store LOB data into the SYSAUX tablespace?
One of the recommendations I have noticed is use separate tablespace for LOB fields. This would be a very big change for us.
Could you please suggest how this issue can be resolved?
I have requested customer's database version. I'll update it once I have it.
I'm assuming customer is using Oracle10 or higher version.