Re: Export a view

From: Limin Guo <lguo.oracle_at_gmail.com>
Date: Thu, 3 May 2007 15:34:49 -0400
Message-ID: <9556d5680705031234g401c3894je6b9ed721ac77f93@mail.gmail.com>

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

-- 
Regards,

Limin Guo.

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

Received on Thu May 03 2007 - 14:34:49 CDT