RE: view re-creation

  • From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
  • To: "veeeraman@xxxxxxxxx" <veeeraman@xxxxxxxxx>, "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • Date: Fri, 17 Jul 2009 08:18:57 +0200

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: