We have a large daily partitioned table. Each partition is in its own tablespace. We have set a few of the oldest tablespaces/partitions to readonly. However, when we are loading to the current partition, for some reason, we are getting the following error:
ORA-00372: file 704 cannot be modified at this time
It is complaining about the datafiles that are readonly? However, we are not even inserting in those files. When we set the these readonly datafiles back to read/write the load executes fine. Any ideas?