Re: Export Oracle View
From: gazzag <gareth_at_jamms.org>
Date: Wed, 6 Feb 2008 07:18:59 -0800 (PST)
Message-ID: <e4fa5784-3d04-4e6e-9a4b-d67da37b611c@i72g2000hsd.googlegroups.com>
Date: Wed, 6 Feb 2008 07:18:59 -0800 (PST)
Message-ID: <e4fa5784-3d04-4e6e-9a4b-d67da37b611c@i72g2000hsd.googlegroups.com>
On 6 Feb, 14:51, l..._at_tech-trans.com wrote:
> Hi!
>
> Anyone have experience to export Oracle view individually?
>
> Ming
What do you mean "export" a view? If you want to see the view definition, DBA_VIEWS can help:
E.g:
SQL> set long 10000
SQL> SELECT TEXT
2 FROM DBA_VIEWS
3 WHERE OWNER='<schema_name>' AND VIEW_NAME='view_name';
Dependent on Oracle version, you could use the DBMS_METADATA package:
select dbms_metadata.get_ddl('VIEW','<view_name>', '<schema>') from dual;
HTH -g Received on Wed Feb 06 2008 - 09:18:59 CST