Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Post Unanswered: Create a Batch File In Oracle

    Hi All,

    I want to create a MS-DOS Batch file that
    1. Connects to Oracle,
    2. Executes a set of commands
    3. Exits out automatically from Oracle.

    Is It Possible If yes please explain how I can go abt doing it.

  2. #2
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Create a Batch File In Oracle

    Originally posted by cmmahesh
    Hi All,

    I want to create a MS-DOS Batch file that
    1. Connects to Oracle,
    2. Executes a set of commands
    3. Exits out automatically from Oracle.

    Is It Possible If yes please explain how I can go abt doing it.
    This an example:

    run.bat file
    ************************************************** *
    sqlplus insudb/libertad@vtofidat @c:\run.sql

    exit
    ************************************************** *

    run.sql
    ************************************************** *
    alter system flush shared_pool;
    exit;
    ************************************************** *
    Joel Pérez

  3. #3
    Join Date
    Jan 2004
    Location
    Venezuela
    Posts
    151

    Re: Create a Batch File In Oracle

    Originally posted by cmmahesh
    Hi All,

    I want to create a MS-DOS Batch file that
    1. Connects to Oracle,
    2. Executes a set of commands
    3. Exits out automatically from Oracle.

    Is It Possible If yes please explain how I can go abt doing it.
    This an example:

    run.bat file
    *************************************
    sqlplus insudb/libertad@vtofidat @c:\run.sql

    exit
    *************************************

    run.sql
    *************************************
    alter system flush shared_pool;
    exit;
    *************************************
    Joel Pérez

Posting Permissions

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