RE: Export a view

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 3 May 2007 11:38:01 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08D86@EXCNYSM0A1AJ.nysemail.nyenet>

J.Dex,

Do you mean to export the data that the View returns or the sql that makes up the view?

If it's the data, you can always create a temporary table from the view and export that table.

Create table view_exp as select * from view_name;

If it's the sql, you can get that from dbms_metadata

Set long 4000
Set trimspool on
Spool view.sql
Select dbms_metadata,get_ddl('VIEW','VIEW_NAME') from dual; Exit

Tom

---

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of J. Dex Sent: Thursday, May 03, 2007 11:03 AM
To: oracle-l_at_freelists.org
Subject: Export a view

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

http://www.freelists.org/webpage/oracle-l Received on Thu May 03 2007 - 10:38:01 CDT