URGENT for COL$
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: URGENT for COL$

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    4

    Question

    Hi there,

    If you are aware that in Oracle 7 we are able to rename column name using col$.

    I did same stuff in 8.0.6 I got modified name in col$ and dba_tab_columns but whenever I describe defination I see old value.

    It is urgent does somebody can help me?

    Thanks
    MUMS

  2. #2
    Join Date
    Sep 2000
    Posts
    4
    Hi Moderator,

    Can you tell me regarding this issue.

    Regards
    MUMS

  3. #3
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    havo to run catalog and catpoc after. Beeware on having indexes or constraints on the column you are modifying

  4. #4
    Join Date
    Feb 2001
    Posts
    389
    Don't do it , but if u r using 8.1.6 ,why not add the new column and then drop the old one.


  5. #5
    Join Date
    Sep 2000
    Posts
    4
    so my qustion will be why shouldn't I do it.

    Does it have a bad effect on Database?

    Thanks
    MUMS

  6. #6
    Join Date
    Feb 2001
    Posts
    41
    No not at all it will update all you datadictionary tables and plsql objects they wont make any change that can affect your database. because they simply recompile you all database objects.
    Best Regards,
    Harsh Shah

  7. #7
    Join Date
    Sep 2000
    Posts
    4
    Thanks to all for your efforts.

    BEst Regards
    MUMS

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    It is not a good practice to change col$ table. Sometimes, you may corrupt data dictionary, that will render the database useless.

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