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.