Re: How to copy view definitions across Oracle instances.

Yeah, it works. Thanks.

HectorTheDog_at_hotmail.com (Kevin Hector) wrote in message news:<7128c4f3.0210230059.1a07a8f4_at_posting.google.com>...
> Hi. There may be other ways to this, but I would use a script which
> creates the views based on the user_views data dictionary view.
> Something like the following (untested - watch for wrap):
>
> declare
> cursor viewcursor is
> select view_name, text from user_views_at_otherdb;
> begin
> for viewrec in viewcursor
> loop
> execute immediate 'create or replace view ' || viewrec.view_name ||
> ' as ' || viewrec.text;
> end loop;
> end;
>
> Good luck
>
> KH
Received on Wed Oct 23 2002 - 17:08:06 CEST