Re: Questions about Materialized View

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 6 Mar 2003 10:13:13 GMT
Message-ID: <b476vp$1r95nm$1@ID-82536.news.dfncis.de>

> 

>> Hi,
>>
>> I am pretty new to Oracle :-)
>>
>> How do I figure out if I am querying a regular table or a materialized
>> view?
>> e.g.: SELECT myID FROM myTable ...
>>
>> Is there any SQL command to tell if "myTable" is a regular table or a
>> materialize view?
>>
>> Can I create an index on any column of a materialized view like if it
>> was a regular table?
>> e.g.: CREATE INDEX ...
>>
>> Thanks in advance,
>> Bombadil.

Sorry, I was to quick answering your question and didn't read exactly what you asked. Thought you wanted to know if an underlying materialized view is queried if a table is accessed...

Anyway:

select object_type from user_objects where object_name = 'MYTABLE';

should answer it

hth
Rene Nyffenegger

-- 
  Projektleitung und Entwicklung in Oracle/C++/C# Projekten
  http://www.adp-gmbh.ch/cv.html

Received on Thu Mar 06 2003 - 04:13:13 CST