Procedure documentationCreating or Changing Synonyms for DBA Tables

 

You can create or change the synonyms for the DBA tables in your Oracle database with BR*Tools.

The results of DBA operations performed using BR*Tools are stored in one component of a multi-component database. You can use this function to change the component where the results are to be stored and where they can be viewed.

For more information, see Additional BRCONNECT Functions.

Prerequisites

The database must be running.

Procedure

  1. Start BRGUI or BRTOOLS.

  2. Choose Start of the navigation path Additional functions Next navigation step Create/change synonyms for DBA tables End of the navigation path.

  3. Set the required options:

    Menu Entry

    Equivalent BRCONNECT

    Command Option

    BRCONNECT profile (profile)

    -p|-profile

    Database user/password (user)

    -u|-user

    Database owner for synonyms (owner)

    -f crsyn -o|-owner

    Message language (language)

    -l|-language

    BRCONNECT command line (command)

    This shows you the BRCONNECT -f crsyn command that is to be executed using the current settings.

  4. To start processing with the selected options, choose Continue.

  5. Check the results by viewing the messages displayed on the screen.