Re: dba_objects

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: Thu, 19 Apr 2001 19:55:42 +0800
Message-ID: <9bmkp0$6cm$4@news.seed.net.tw>

"Ms. D.H. Harvey" <qq45_at_liverpool.ac.uk> ¼¶¼g©ó¶l¥ó news:9bh7eg$fn2$1_at_news.liv.ac.uk...
> ,Internally used object type for materialized views.
>
> See asktom answer to 'Snapshot / Materialized View' Thursday
> April 12, 2001
>
> HTH Helen

What you said is only one case for the "UNDEFINED" type on some "old" versions.

On Oracle 8i release 8.1.6:
Snapshot/Materialized views are displayed as TABLE in OBJECT_TYPE column of DBA_OBJECTS view.

The objects you saw are probably LOB segments, you can check thir type#. Type#21 are LOB segments associated with BLOB/CLOB columns.

I don't use Oracle8.1.7, they may be changed. Received on Thu Apr 19 2001 - 06:55:42 CDT