Wishlist - browser

[hbar]

It'd be handy if there were a separate folder in the browser for materialized views, instead of lumping them in with the rest of the tables.

Or did I just overlook a handy option?

 

[Marco Kalter]

Full support for materialized views will be added in 6.0.

------------------
Marco Kalter
Allround Automations

 

[Stew Stryker]

I have a favorite schema that's not where I develop that and I'd like to see various objects from it in the browser. The schema name is 'AEO'.

So created a folder titled "AEO Objects', then created child folders for the various objects, entering something like this in the WHERE clause:

object_type = 'PROCEDURE' AND owner = 'AEO'

All worked fine except for 'MATERIALIZED VIEW'

I know I can see mviews in that schema. But the query

SELECT *
  FROM all_objects
 WHERE owner = 'AEO'
 AND object_type LIKE '%VIEW%';

Lists the objects with object_type = 'VIEW', along with the other (non-materialized) views.

Is there any way I can create a folder that will pull in Materialized Views, or do I have to be content adding them manually to the folder?

 

[Stew Stryker]

Marco,

Sorry to be a pest, but do you have any opinions about this?

Thanks,

 

[Marco Kalter]

Sorry, I missed this question.

I tried it and it works just fine. Can you verify that materialized views are returned in the all_objects view? Note that Oracle 8.1.7 had a bug that would hide all materialized views from the all_objects view.

 

[Stew Stryker]

Thanks for the reply.

You're right that the query:

SELECT *
  FROM all_objects
 WHERE owner = 'AEO'
 AND object_type LIKE '%VIEW%';

Doesn't list the materialized views from this schema. We're running 10g, release 1.

I recreated one of those materialized views in my schema and I can definitely see it with this:

SELECT *
  FROM user_objects
 WHERE object_type = 'MATERIALIZED VIEW'

It's interesting to me that the Browser can those mat views IF I change the filter to be that AEO schema. So I'm thinking:

• It's not a grants issue that prevents me from seeing objects in that schema,
• Developer is using a different query than above.

I'm also guessing if I could copy the standard browser folder object for Materialized View and then add the schema qualifier it should work. But I don't know if I can do that?

Thanks again,