Database Administration (MOSC)

MOSC Banner

invalid table

In our database (19.15 on Solaris Sparc) there are many tables with status INVALID

Example; MDSYS.GridFile1706_TAB

There's more invalid objects but I think the invalid tables are the cause of that. So I'm trying to find how and what for these objects (as tables are not often ... invalid). I found they have columns of type XML. But, that's it, then I'm stuck

Why would they be invalid ?

Note, the Spatial component is also INVALID, but that I have as a seperate target to fix. Here is to explain invalid tables (above is just 1 example, there are many more).

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