Re: 'O' Type Constraints

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Tue, 24 Nov 98 10:25:27 +0200
Message-ID: <AJtrcMsK42@protasov.kiev.ua>

Hi,

These are read only constraints of views:

SVRMGR> create or replace view v1 as select * from dual with read only; Statement processed.
SVRMGR> create or replace view v1 as select * from dual with read only constraint v1_read_only;
Statement processed.

Andrew Protasov

> Does anyone know anything about 'O' type constraints? I have discovered
> some constraints against some snapshots I have (in Oracle 7.3.x). The
> constraints are disabled, and I am just trying to determine what they
> might have been intended for.
>
> I have found nothing in any of the documentation and none of the other
> DBA's in our shop have any idea what that type constraint it.
>
> Charlie Crissman
> Sr. Oracle DBA
> CSX Technology
> Jacksonville, FL
> charlie_crissman_at_csx.com
Received on Tue Nov 24 1998 - 02:25:27 CST