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