How to copy view definitions across Oracle instances.
From: Zack Li <zack_li001_at_yahoo.com>
Date: 22 Oct 2002 16:07:08 -0700
Message-ID: <bb9516b7.0210221507.48ad8902_at_posting.google.com>
Date: 22 Oct 2002 16:07:08 -0700
Message-ID: <bb9516b7.0210221507.48ad8902_at_posting.google.com>
Hi,
I am having a situation that I want to copy all the view definitions from instance A to instance B. For table definitions, I created a database link to instance B in A, and do "create table .. as select * from ..._at_db_link".
But how to do the similar things for views?
Your help is greatly appreciated,
Thanks. Received on Wed Oct 23 2002 - 01:07:08 CEST