RE: view re-creation

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Sun, 19 Jul 2009 00:41:28 +1000
Message-ID: <008a01ca07b5$d80917b0$881b4710$_at_com>

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  

http://www.mcs.csueastbay.edu/support/oracle/doc/10.2/server.102/b14215/dp_e xport.htm#i1009903  

> 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.

Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge_at_uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be <http://www.uptime.be/> disclaimer  

Checked by AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.13.17/2242 - Release Date: 07/16/09 18:00:00

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 18 2009 - 09:41:28 CDT