+ Reply to Thread
Results 1 to 4 of 4

Export Oracle View

  1. Export Oracle View

    Hi!

    Anyone have experience to export Oracle view individually?

    Ming

  2. Re: Export Oracle View

    On 6 Feb, 14:51, l...@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='' AND VIEW_NAME='view_name';

    Dependent on Oracle version, you could use the DBMS_METADATA package:

    select dbms_metadata.get_ddl('VIEW','', '') from
    dual;

    HTH

    -g


  3. Re: Export Oracle View

    On Feb 6, 10:18*am, gazzag wrote:
    > On 6 Feb, 14:51, l...@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='' AND VIEW_NAME='view_name';
    >
    > Dependent on Oracle version, you could use the DBMS_METADATA package:
    >
    > select dbms_metadata.get_ddl('VIEW','', '') from
    > dual;
    >
    > HTH
    >
    > -g


    What version of Oracle?

    The traditional Oracle export utility, exp, does not have an export
    veiw only feature. The newer expdp utility does have DDL and object
    specific export options.

    Depending on your version the dbms_metadata package can be used to
    extract the view DDL.

    You can write SQL to build view source via selects against Oracle
    rdbms dictionary views using dba_views as mentioned but be advised
    that the text in dba_views does not correctly produce the view column
    list names for all views. To do that you have to read the view column
    names from dba_tab_columns.

    HTH -- Mark D Powell --


  4. Re: Export Oracle View

    On 2月6日, 下午11時18分, gazzag wrote:
    > On 6 Feb, 14:51, l...@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='' AND VIEW_NAME='view_name';
    >
    > Dependent on Oracle version, you could use the DBMS_METADATA package:
    >
    > select dbms_metadata.get_ddl('VIEW','', '') from
    > dual;
    >
    > HTH
    >
    > -g


    It means export views by exp.exe. Thx!

+ Reply to Thread