Hi,
we use dbForge for Oracle Pro. A trigger suddenly disappeared. We try to find out what was recently happened by our clients. Does dbForge has a log file (history) of all SQL statements fired to the db?
Fired SQL Statments Logging
-
alexa
Re: Fired SQL Statments Logging
You can turn on logging as follows:
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Restart dbForge Studio for Oracle.
A *.log file can be found in the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for Oracle\'.
1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Environment -> Output' branch.
3. Select the 'Write queries sent by the program to the SQL Log' and 'Log application errors' options.
4. Unselect the 'Delete application log after closing' option. Click 'OK'.
5. Restart dbForge Studio for Oracle.
A *.log file can be found in the directory '%SystemDrive%\Users\%UserName%\AppData\Roaming\Devart\dbForge Studio for Oracle\'.