messed up oracle xml

From: steve <me_at_me.com>
Date: Tue, 25 May 2004 06:03:10 +0800
Message-ID: <0001HW.BCD8921E00027548F05095B0@news.newsguy.com>

hi,

I have an oracle 9.2.0.1 database that had one of the internal xml tables deleted. ( why ? , because the XML manual clearly states DO NOT DELETE the table, so someone decided to try.)

after upgrade using the 9.2.0.4 install disks and the following

startup upgrade
@?/catpatch.sql

I am getting an error that is causing the script to abort. also the XML is being marked as invalid.

SELECT comp_name, status, substr(version,1,10) as version from dba_registry;

STATUS VERSION
----------- ----------
Oracle interMedia
UPGRADED 9.2.0.0.0 Spatial
VALID 9.2.0.4.0 Oracle XML Database
INVALID 9.2.0.4.0 running
@?/catproc.sql does not fix the problem.

1.is there any way to drop the xml installation & tables , safely ? (will deleting the xml table space work)
2. is there any way to Force reinstallation of the XML Schima?

thanks Received on Mon May 24 2004 - 17:03:10 CDT