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 Tools 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.