Using the Case Insensitivity Wizard on a Table

If you run the Case Insensitivity Wizard to configure a large number of columns for a CIAI query, or if you must use a nondefault method or index strategy, then you can use an input file. The wizard reads the input file, and then configures the columns in the file. Using an input file allows you to control the configuration options that the Case Insensitivity Wizard uses. Oracle provides recommended input files. For more information, see Input File You Can Use with the Case Insensitivity Wizard.

To use the Case Insensitivity Wizard on a table

1. In Siebel Tools, open the repository.

   For more information, see Choosing the Correct Repository when Running the Case Insensitivity Wizard.

2. Lock the tables that are listed in the input file.

3. Click the Tools menu, click Utilities, and then click Case Insensitivity.

4. Choose Administer the Columns Listed in This File, and then click Browse.

   Siebel Tools displays the tools\objects directory, which contains the default csv input files.

5. Choose the csv file, click Open, and then click Next.

   The Case Insensitivity Wizard validates the following:

   • Format of the input file

   • Eligibility of all tables and columns

   If the file contains an error, then the wizard lists the records that contain the errors. If you continue, then the wizard skips records that contain errors. If errors exist, then click Export to export the error list to a text file, correct the errors, and then restart the Case Insensitivity Wizard.

   For more information, see Input File You Can Use with the Case Insensitivity Wizard.

6. Click Next.

   The Case Insensitivity Wizard displays the records in the input file.

7. Review the configuration settings and verify they are correct.

   If you must modify any configuration settings, do the following:

   1. Click Export.

      The Case Insensitivity Wizard exports the list to a text file.

   2. Edit the text file, and then restart the Case Insensitivity Wizard, specifying the edited text file as the input file.

8. Click Next.

   The Case Insensitivity Wizard displays the modifications it will make to repository tables and indexes.

9. Optional. If you must save a record of the modifications, then click Export.

   The Case Insensitivity Wizard writes the modifications to a text file.

10. Click Finish.

    The Case Insensitivity Wizard configures the columns in the Siebel repository to support a CIAI query.

11. In the Tables list, click Apply/DDL.

12. Compile your modifications.