I did it before and it works. I know that. I had only one user before. Now I have 9 users. Some of their tables have the same names. For example 3 users have a table COUNTRY. I create index but how I will specify that the INDEX1 belongs to USER1. For example CREATE INDEX IE1_COUNTRY(COUNTRYCODE) ON (COUNTRY); Should I do the following CREATE INDEX IE1_COUNTRY(USER1.COUNTRY.COUNTRYCODE) ON (USER1.COUNTRY);
If yes then what is the syntax because it gives me the syntax error.
By the way do you think I should add a qualifier to the name of the index? I am curios about that because I was trying to drop the index and it looks like it was dropped. But then in Administrative tools I selected the table and then selected "list indexes" all of the indexes were there, nothing was really dropped. I had to drop all the tables and to recreate them again.