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@xxxxxxxxx>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@xxxxxxxxx
> tel. +32 (0)3 451 23 82
> http://www.uptime.be
> disclaimer
>

Other related posts: