Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to fix this spécial french accent issue

Mohamed HouriNov 29 2022 — edited Nov 29 2022

Hello
Here's the model and the issue

SQL> create table t1 (id number, d date, vc varchar2(10));

Table created.

-- notice the special character in the index name 
SQL> create index t1_idx_mémo on t1(id); 

Index created.

Now I want to, say, rebuild this index (or any other action on this index)


SQL> select 
      'alter index '||owner||'.'||index_name ||' rebuild parallel 4;' 
            sql_stmt 
     from 
       all_indexes 
    where owner='C##MHOURI' 
     and table_name='T1';

SQL_STMT
---------------------------------------------------------------
alter index C##MHOURI.T1_IDX_M??MO rebuild parallel 4;

SQL> alter index C##MHOURI.T1_IDX_M??MO rebuild parallel 4;
alter index C##MHOURI.T1_IDX_M??MO rebuild parallel 4
               *
ERROR at line 1:
ORA-00911: invalid character

What would you do to fix this issue at the session level?
Thanks
Mohamed Houri

This post has been answered by Mohamed Houri on Dec 2 2022
Jump to Answer
Comments
Post Details
Added on Nov 29 2022
13 comments
703 views