In normal operation, a Spotlight connection may run an ALTER SYSTEM query on a target database. Use the Oracle DDL options to stop Spotlight from altering the target database.
To open the Spotlight on Oracle DDL option
Select one of the following options:
| Option | Description |
|---|---|
| Generate DDL when Spotlight alters database | Select to have the text of proposed ALTER SYSTEM queries written to a DDL file. |
| Notify me when Spotlight logs a DDL statement | Select to be notified when Spotlight writes to the DDL file. |