You can configure an Oracle connection to work locally with Update Manager.

Before you begin

Verify that the ODBC data source that you use is a 64-bit system DSN. See Create a 64-Bit DSN.

Procedure

  1. Create a tablespace specifically for Update Manager by using the following SQL statement:
    CREATE TABLESPACE "VUM" DATAFILE 'ORACLE_BASE\ORADATA\VUM\VUM.dat' SIZE 1000M AUTOEXTEND ON NEXT 500K;

    In this example, ORACLE_BASE is the root of the Oracle directory tree.

  2. Create a user, such as vumAdmin, for accessing this tablespace through ODBC.
    CREATE USER vumAdmin IDENTIFIED BY vumadmin DEFAULT TABLESPACE “vum”;
  3. Either grant the dba permission to the user, or grant the following specific permissions to the user.
    grant connect to vumAdmin
    grant resource to vumAdmin
    grant create any job to vumAdmin
    grant create view to vumAdmin
    grant create any sequence to vumAdmin
    grant create any table to vumAdmin
    grant lock any table to vumAdmin
    grant create procedure to vumAdmin
    grant create type to vumAdmin
    grant execute on dbms_lock to vumAdmin
    grant unlimited tablespace to vumAdmin
    # To ensure space limitation is not an issue
  4. Create an ODBC connection to the database.

    See the following example settings:

    Data Source Name: VUM
    TNS Service Name: VUM
    User ID: vumAdmin