Re: Read Only Tablespace Issue in 8.1.5 - Any Guidance??

Jonathan and John,

I have to say, you guys are fun to read. I've been monitoring the ORACLE-L for more than a year, but only recently started reading the newsgroups. Basically, there is very little traffic on the list on weekends, so I looked for some more material.

Good stuff.

Anyone going to the IOUG in Orlando the end of the month?

Paul

"Howard J. Rogers" wrote:
>
> Thanks Jonathan.
>
> Pesky critters, huh?!
>
> Regards
> HJR
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:986385034.3897.0.nnrp-01.9e984b29_at_news.demon.co.uk...
> >
> > Darn !
> >
> > You published before I had a chance to put this on
> > my web-site. ON THE VERSION I WAS USING,
> > the extents were logged into UET$ - so LMTs don't
> > avoid every access to the data dictionary.
> >
> > It seems that the next time SMON kicks in with
> > its 'any temp segments' test (e.g. at database startup)
> > AND the LMT is read-write, the entries from UET$
> > are applied to the bitmap header and the space is cleared.
> >
> > --
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > Howard J. Rogers wrote in message <3acb0938_at_news.iprimus.com.au>...
> > >Sorry to spring this one so late, but....
> > >
Received on Tue Apr 10 2001 - 02:26:45 CDT