DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How can I run the script to get data from DB

  1. #1
    Join Date
    Mar 2004
    Location
    Hong Kong
    Posts
    1

    How can I run the script to get data from DB

    I got following script, but I don't how to run at the DB. Any one can help me that can running oracle 8.17 at win2k platform??

    set head off
    set veri off
    set feed off
    set echo off
    spool c:\temp\openview..sql
    select 'analyze table '||owner||'.'||table_name||'
    compute statistics for table;'
    from dba_tables where table_name like 'OVIPA%';

    select 'analyze table '||owner||'.'||table_name||'
    compute statistics for all indexes;'
    from dba_tables where table_name like 'OVIPA%';

    spool off
    set head on
    set veri on
    set feed on
    set echo on
    @c:\temp\openview.sql

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    sqlplus system/******@db1 @filename.sql
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width