Database Administration (MOSC)

MOSC Banner

invalid table

19.15 database on Solaris Sparc, a lot of objects are invalid

Including a lot of invalid tables. Names like cpResAssignNotPref974_TAB


Some other invalid objects (views, packages) cannot be compiled because they state:

ORA-04063: table "X.Y" has errors

So I understand that the tables have errors ... but what does that mean ?

I found at least one such a table with an XMLTYPE as column type for such a table, so I presume that be part of the problem.

But it comes back to this: how can this be invalid ? The table was created, and that must have been OK because otherwise the table woumdn't exist anymore. So I guess some alter command was done ... done, but resulting in an invalid object ?!

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