Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table status invalid after schema registeration

350199Jun 5 2006 — edited Jun 6 2006

Hi,

After registering a schema, I find some of the generated tables are in invalid status after querying ALL_OBJECTS.
The table names are mostly like SYS_NTfHcSTNXCTeSAdEywrov4PQ==

Also there are some tables ending with $xd which are invalid.

What to do with these invalid tables? is there a way to compile them or something?
I haven't yet inserted any xml instance in the DB.
Please give suggestions

Thanking you
Devashish

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2006

Added on Jun 5 2006

#performance-availability, #xml-db

7 comments

574 views