Update the "_replace_virtual_columns" Setting

Use this procedure to update the"_replace_virtual_columns" setting in your Oracle database from false to true.

• This procedure must be performed by your database administrator.
• All users must log out of Cobra.

To update the "_replace_virtual_columns" setting:

1. Connect to the Oracle database using Oracle SQL Developer or any similar application.
2. To update the "_replace_virtual_columns" setting, run the following query:

   alter system set "_replace_virtual_columns"=true; commit;

3. To verify that the "_replace_virtual_columns" setting is now set to true, run the following query:

   SELECT NAME, VALUE FROM V$PARAMETER WHERE NAME = '_replace_virtual_columns';

   Note: Running this query must return a single row with the VALUE column set to TRUE.