Re: Question about bazaar sys views (9.0.1 Win)

Well, the ALL_* views are still there, only they aren't prefixed with an underscore, for example --

ALL_REPCOLUMN
ALL_REPCOLUMN_GROUP
ALL_REPCONFLICT
ALL_REPRESOLUTION

are all there under as their own entities, but there are copies (uncompilable) of these views with an underscore before them.

Tom
www.oraclepower.com

"Andrew Hardy" <nobody_at_spam.from.news.AdvanticaTech.com> wrote in message news:a3dm1g$fhu$1_at_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 - 11:42:04 CST