Re: Export a view

  • From: "Limin Guo" <lguo.oracle@xxxxxxxxx>
  • To: cemail_219@xxxxxxxxxxx
  • Date: Thu, 3 May 2007 15:34:49 -0400

data pump export allow you to export view.

expdp userid/passwd include=view:"='VIEW_NAME_EXPORTED'" schemas=SCHEMA_NAME

you may need "\" in front of double quota if you are on unix or linux.

Hope this helps.


On 5/3/07, J. Dex <cemail_219@xxxxxxxxxxx> wrote:

Is there any way to do an export of a view in either 9i or 10g?    I am
pretty sure the answer is no, but thought I would ask anyway.

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office

Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/

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





--
Regards,

Limin Guo.

Other related posts: