Re: duplicate view

db2group88_at_yahoo.com wrote:

> we are using oracle 10g. Our application required to duplicate a view
> from existing view during run time, which means the only difference is
> different view name and different table name, but the definition is the
> same. in order to do that, i would like to retrieve the catalog info
> about the view. Do you know which view under sys schema provide that
> info?

This screams loudly of a very bad design. Please explain what is making you want to create a view at run time in a production database.

No doubt 10 people will tell you why you shouldn't and how to avoid it. And let me be the first. ;-) Don't do it!

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)