Bigfile Tablespaces for Oracle Text: Any known issues? Anyone used it successfully?
Dear all,
I'm considering the introduction of BIGFILE tablespaces in an environment with three large Oracle Text CONTEXT indexes based on 19c with RU 19.18.
Checking MOS for any issues/bugs (quick glance) I did not see anything that would deter me from using BIGFILE tablespaces.
Since a reorganization is more or less due I'm thinking of reorganizing into the BIGFILE tablespaces to then dropping the SMALLFILE tablespaces.
There might be unpublished bugs. So if anyone would be willing to share their thoughts on BIGFILE in general (stability) and especially who has been using BIGFILE with Oracle Text and how did it go? I'd appreciate it.