-
How do I do this in SQLPLUS
A new index is created on an existing table i.e
CREATE INDEX MENUINDX##EXECMODE ON MENUINDX(U##EXECMODE, PROGRESS_RECID);
I need a mechanism to query back preferably all new indexes created or all indexes on Tables owned by user A. And then issue a command similar to
update menuindex
set U##EXECMODE=upper EXECMODE;
So that all U## fields have a value which is the uppercase equivalant to fields with similar name i.e Execmode = will hold lowercase value and U##Execmode will hold uppercase value.
--------------------------------------------------------------------------------
-
Have you tried:
update menuindex
set U##EXECMODE=upper(EXECMODE);
???
-
I think you have to recreate the indexes of the user. The best way is to export in user mode and import with indexfile= to extract index creation scripts, modify these as per your requirement and replace the old indexes.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|