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!

Problem in Re-Registering XML Schema: Generated table already exists

299623Nov 17 2003 — edited Jan 26 2004

Hi,

I'm facing strange issue in re-registering a schema. The tables to be generated by the xml schema are not existing in the database, but still when i try to register the schema i keep getting the error 'ORA-31905 cannot generate table :"USERNAME.TABLE_NAME" already exists'

I have checked all data dictionary views (all_tables, dba_cml_tables etc) but the table does not exist for the user at all !!

Please help resolve how to get rid of the phantom table and re-register the schema

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 23 2004

Added on Nov 17 2003

#performance-availability, #xml-db

3 comments

305 views