RE: view re-creation
Date: Sun, 19 Jul 2009 00:41:28 +1000
Use expdp to dump the view definitions and use impdp to write them all to a textfile.
For an example lookup include in this link
> expdp hr/hr INCLUDE=VIEWS DUMPFILE=dpump_dir1:exp_inc.dmp NOLOGFILE=y
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Ram Raman
Sent: Saturday, July 18, 2009 2:39 AM
To: D'Hooge Freek
Cc: Bobak, Mark; Gus Spier; ORACLE-L
Subject: Re: view re-creation
We directly imported the views in to the target database using datapump without going through a text file. That worked for us. We have achieved what we wanted.
However, it will still be nice to be to find a solution to be able to edit the files if needed for future. We will test out ddlwizard too.
Thanks to everyone who helped.
On Fri, Jul 17, 2009 at 1:18 AM, D'Hooge Freek <Freek.DHooge_at_uptime.be> wrote:
If you are on 10g or higher you could use datapump to extract only the views
(using the include parameter).
And then import it into the other database.
Checked by AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.13.17/2242 - Release Date: 07/16/09 18:00:00