SELECT * issued when viewing view ddl.

[Brad Buske]

Why is a SELECT * executed when simply looking at view ddl? The view I'm generating ddl for takes about 10 minutes to execute. Tried generating ddl using DBMS_METADATA, but DBA won't give me priv's. Anybody else experience this problem? I have version 7.0.1.1066 installed.

 

[Marco Kalter]

It is not executed, the query of a view is merely described (parsed) to get the column list.