DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How do I do this in SQLPLUS

  1. #1
    Join Date
    Dec 2002
    Posts
    28

    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.

    --------------------------------------------------------------------------------

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492
    Have you tried:

    update menuindex
    set U##EXECMODE=upper(EXECMODE);

    ???

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    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.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width