Re: No logging issue

From: Howard J. Rogers <howardjr_at_www.com>
Date: Mon, 7 May 2001 07:59:37 +1000
Message-ID: <3af5c94b@news.iprimus.com.au>

But, as Sybrand is implying, you can alter a table to be nologging, and then alter it back -and a check on the views he mentions will tell you what it is *currently* sitting there as, not what states it might have flipped through earlier.

Regards
HJR "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tfaq59jer3trf0_at_beta-news.demon.nl...
>
> "ff" <cfs3526_at_ureach.com> wrote in message
> news:cdcJ6.18146$Aj1.7267711_at_typhoon2.ba-dsg.net...
> > Is there anyway we can check any data dictionary to see if any nologging
was
> > performed?
> >
> > Thanks
> >
> >
>
> No, you can't check whether it was actually used.
> You can check whether it is defined
> (in dba_tables, dba_tablespaces etc.)
>
> Hth,
> Sybrand Bakker, Oracle DBA
>
>
>
Received on Sun May 06 2001 - 16:59:37 CDT