Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> duplicate view

duplicate view

From: <db2group88_at_yahoo.com>
Date: 7 Dec 2004 15:11:02 -0800
Message-ID: <1102461062.101037.254680@z14g2000cwz.googlegroups.com>


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? Received on Tue Dec 07 2004 - 17:11:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US