Re: Export a view

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Thu, 3 May 2007 10:11:52 -0700
Message-ID: <3b0f44a10705031011l7e1b4bb9t7137dd3380ffc54@mail.gmail.com>

Hi,

I am pretty sure the answer is YES. You can export the contents of a view just by tweaking the EXUnTAB view. Basically export does a simple select to get the data from the table and if you can fool export program to expose your view as table, it will export the contents of that view (thinking it is a table).

-Gopal

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

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 03 2007 - 12:11:52 CDT