Re: Export Oracle View

From: <leo_at_tech-trans.com>
Date: Thu, 7 Feb 2008 07:35:02 -0800 (PST)
Message-ID: <6d799423-4a92-4e2c-a152-6e8fb9edbbf5@c4g2000hsg.googlegroups.com>


On 2$B7n(B6$BF|(B, $B2<8a(B11$B;~(B18$BJ,(B, gazzag <gar..._at_jamms.org> wrote:
> 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

It means export views by exp.exe. Thx! Received on Thu Feb 07 2008 - 09:35:02 CST

Original text of this message