Re: view re-creation

  • From: Ram Raman <veeeraman@xxxxxxxxx>
  • To: "D'Hooge Freek" <Freek.DHooge@xxxxxxxxx>
  • Date: Fri, 17 Jul 2009 11:38:59 -0500

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

Other related posts: