Re: Question about bazaar sys views (9.0.1 Win)

Let me reitirate --

These views I expect to exist, and they compile fine --

ALL_REPCOLUMN
ALL_REPCOLUMN_GROUP
ALL_REPCONFLICT
ALL_REPRESOLUTION

These views are there for some reason and are prefixed with an underscore that isn't allowed in oracle view naming convention --

_ALL_REPCOLUMN
_ALL_REPCOLUMN_GROUP
_ALL_REPCONFLICT
_ALL_REPRESOLUTION

^---------------- Notice the underscore before the name.

Tom
www.oraclepower.com

"Tom Dyess" <tdyess_at_dyessindustries.com> wrote in message news:MrA68.184420$_w.28792402_at_typhoon.tampabay.rr.com...
> 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:55:44 CST