Re: '?' in BROKEN column of USER

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 20 Jun 2002 22:32:04 +0200
Message-ID: <kod4hu0cube4mj2gufhqcdn10u4h5sqs9j@4ax.com>

On Thu, 20 Jun 2002 10:25:26 +0200, "Matthieu DEGLIN" <mdeglin_at_remove-me.partner.auchan.com> wrote:

>Hello,
>
>The column BROKEN of the USER_SNAPSHOTS is set to ? for my only snapshot
>group. I've already encounter 'N' et 'Y' but that's tehe first time i see a
>?.
>
>What does it mean ?
>
>For information, I've suppress the Oracle Job that refresh the Snapshots.
>The DBMS_REFRESH is yet execute by a Unix shell. I guess it's is linked to
>my "problem".
>
>Thanks.
>
>Matthieu DEGLIN
>

My guess is that the associated snapshot job has never executed. Hence the status of broken is unknown.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 20 2002 - 15:32:04 CDT

Re: '?' in BROKEN column of USER_SNAPSHOTS