Oracle Text (MOSC)

MOSC Banner

Bigfile Tablespaces for Oracle Text: Any known issues? Anyone used it successfully?

edited Nov 4, 2023 8:58AM in Oracle Text (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center