Transferring Alert Definitions
You can use the Transfer Alert Definitions window to transfer an alert definition to another database, or make a copy of an existing alert.
To transfer or copy an alert definition:
1. Choose from the Special menu of the Alerts form, Transfer Alert.
2. In the Source Alert region of the Transfer Alert Definition window, enter:
- the name of the application that owns the alert you want to transfer
- the name of the alert you want to transfer
- the username and password of the database where the alert you want to transfer resides
Also include any necessary SQL*Net syntax to indicate where your database resides. You may use SQL*Net V1 or SQL*Net V2 syntax. In the Database field, enter the username, password, and SQL*Net syntax in the following format:
username/password@SQL*Net_syntax
Here is an example of SQL*Net V1 syntax to specify the database location:
sysadmin/friday@T:testing:db2
Here is an example of SQL*Net V2 syntax to specify the database location:
sysadmin/friday@db2
3. Similarly, in the Destination Alert region, enter:
- the name of the application you want to transfer the alert to
- the name you want to assign to the new alert
- the database where you want the new alert to reside
4. Choose Transfer to complete the alert transfer.
See Also
Oracle Alert Naming Conventions