Creating or Changing Synonyms for DBA Tables

Use

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

·        Make sure you have set the necessary BRCONNECT parameters in the initialization profile init<DBSID>.sap, because BRTOOLS uses these when it calls BRCONNECT.

·        The database must be running.

Procedure

...

       1.      Start BRGUI or BRTOOLS.

       2.      Choose Additional functions ® Create/change synonyms for DBA tables.

       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.