Object Search, Lacking TABLE object in Search Source (88835)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Object Search, Lacking TABLE object in Search Source
Description

Why is "Table" not in the list of "Source" objects that can be searched for a given string? Materialized view is pretty much the same thing, and it appears there.
Resolution

Generally Toad only queries the all_source table for the "search source" group.
Tables are not one of the object types in that table.
On the other hand, neither are views and MVs.
However, table and MV DDL are simply CREATE statements and storage params (and SELECT statements, of course).

Feedback submitted.

Was this article helpful?

[Select Rating]

Title