Re: Object table oddity

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Jan 1999 21:32:27 -0000
Message-ID: <916178137.19434.3.nnrp-08.9e984b29@news.demon.co.uk>

Object tables are described in DBA/USER/ALL_object_tables I got caught by this one too.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

mgogala_at_rocketmail.com wrote in message <77blb5$fb4$1_at_nnrp1.dejanews.com>...
>I was toying around with Oracle 8.0.5 with object option on Solaris 2.6 and
>here is what happened:
>- I created a type and and an object table of that type.
>- I inserted some records in the table.
>- I queried USER_TABLES and the table I created WAS NOT THERE. It was
however
> in the USER_OBJECTS with the type 'TABLE'.
>I queried the table and voila, it really exists. To make long story short,
>it looks like the OBJECT TABLES ARE NOT SHOWN IN USER_TABLES. Does anyone
>have similar experiences or (hopefully) an explanation?
>Mladen Gogala
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Jan 12 1999 - 15:32:27 CST