| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Rename ORA-14047
Try using:
ALTER INDEX temp_idx_name RENAME TO old_idx_name
It appears that the keyword RENAME is missing from the statement.
>
> ALTER INDEX temp_idx_name TO old_idx_name
> /
>
> However when I do this I get ORA-14047 stating that
>
> ALTER TABLE | INDEX RENAME may not be combined with other operations
>
> And i cant see what other operations I am doing !
Received on Wed Jan 21 2004 - 13:33:07 CST
 |
 |