RE: Export a view
- From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 May 2007 11:38:01 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of J. Dex
Sent: Thursday, May 03, 2007 11:03 AM
To: oracle-l@xxxxxxxxxxxxx
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
