Re: Question about bazaar sys views (9.0.1 Win)

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Fri, 1 Feb 2002 09:10:02 -0000
Message-ID: <a3dm1g$fhu$1@sun-cc204.lut.ac.uk>

The '_ALL%' views are pretty standard, even if the name is a little strange!

There is no need to drop them.

Andy

"Tom Dyess" <tdyess_at_dyessindustries.com> wrote in message news:Qep68.498591$oj3.95176653_at_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 Fri Feb 01 2002 - 03:10:02 CST