Home -> Usenet -> comp.databases.oracle -> Re: How to copy view definitions across Oracle instances.

Re: How to copy view definitions across Oracle instances.

From: Kevin Hector <HectorTheDog_at_hotmail.com>
Date: 23 Oct 2002 01:59:57 -0700
Message-ID: <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 - 10:59:57 CEST












Original text of this message