Проверка изменений базы данных Oracle Siebel при помощи утилиты Interactive SQL

Даю подробное описание на английском языке.

The local databases used for Siebel developers and remote users as well as the Siebel Sample database are Sybase Adaptive Server Anywhere databases. We can use Sybase's Interactive SQL utility, which is delivered with Siebel Tools to connect to the database and verify that the physical changes have been applied. We must also use this utility to execute DDL scripts generated by Siebel Tools (as described in the information box above).

 

The following procedure describes how to use Interactive SQL to connect to the local developer database:

1. Use Windows Explorer to navigate to the BIN subdirectory of the Siebel Tools installation folder.

2. Double-click the dbisql.exe program.

3. In the Connect to Adaptive Server Anywhere dialog, click the Database tab

4. Click the Browse button.

5. In the Files of type drop-down at the bottom of the browse dialog, select All Files (*.*).

6. If you are using a local developer database, continue with step 7. If you are using the Siebel Sample database, proceed to step 8.

7. To connect to a local developer database, execute the following steps:

  • Browse to the LOCAL subdirectory of the Siebel Tools installation folder.
  • Select the sse_data.dbf file and click Open.
  • Click the Login tab in the Connect to Adaptive Server Anywhere dialog.
  • Enter SIEBEL as the User ID.
  • Enter your local database password in the Password field.
  • Click OK.

8. To connect to a Siebel Sample database, execute the following steps:

  • Browse to the SAMPLE\UTF8 subdirectory of the Siebel Client installation folder.
  • Select the sse_samp.dbf file and click Open.
  • Click the Login tab in the Connect to Adaptive Server Anywhere dialog.
  • Enter DBA as the User ID.
  • Enter SQL in the Password field.
  • Click OK.

9. In the Command window in the bottom area of the Interactive SQL utility, enter an SQL statement similar to the following: select * from CX_AHA_DOC

10. Click the Execute button.

11. Verify that no Table not found… error is displayed and that the columns of the table appear in the Data window. We can scroll right in the Data window to verify the existence of all columns we defined in Siebel Tools.

12. Close the Interactive SQL utility.

 

На скриншоте показана утилита Interactive SQL после исполнения произвольного SQL запроса:

 

Вас заинтересует / Intresting for you:

Мониторинг всей системы с испо...
Мониторинг всей системы с испо... 1317 просмотров Горр Tue, 21 Nov 2017, 13:18:46
Анализ больших данных на платф...
Анализ больших данных на платф... 1302 просмотров Горр Sun, 07 Oct 2018, 07:26:27
О применении технологии Oracle...
О применении технологии Oracle... 2871 просмотров Administrator SU Sun, 07 Oct 2018, 06:04:08
Облачные вычисления Oracle
Облачные вычисления Oracle 2625 просмотров Боба Sun, 07 Oct 2018, 07:26:27
Войдите чтобы комментировать

ildergun аватар
ildergun ответил в теме #7835 05 янв 2017 17:45
На сколько вообще Oracle Siebel распространен в России? Кто-то юзает на предприятиях?