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.

Troubleshoot Oracle Error ORA-600 [kkqcscpcky:ficand] While Running Query with Parameter "_replace_virtual_columns=false"

Parent Topic:

Troubleshoot Oracle Error ORA-600