Question about bazaar sys views (9.0.1 Win)

From: Tom Dyess <tdyess_at_dyessindustries.com>
Date: Fri, 01 Feb 2002 04:57:20 GMT
Message-ID: <Qep68.498591$oj3.95176653@typhoon.tampabay.rr.com>

When I was cleaning up invalid objects, I ran the following query on an Oracle 9.0.1 database on Win2K. I got the following which is bazaar because you can't have views prefixed with an underscore. Can anyone reproduce this or have an explanation? (you may want to get rid of the invalid)

SELECT object_name FROM ALL_OBJECTS
WHERE status = 'INVALID'
AND owner IN ('SYS','SYSTEM')

OBJECT_NAME

---

_ALL_REPCOLUMN
_ALL_REPCOLUMN_GROUP
_ALL_REPCONFLICT
_ALL_REPRESOLUTION

4 rows retrieved

Tom
www.oraclepower.com Received on Thu Jan 31 2002 - 22:57:20 CST