duplicate view

Giganews Newsgroups
Subject: duplicate view
Posted by:  db2group…@yahoo.com (db2group…@yahoo.com)
Date: 7 Dec 2004

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?

Replies