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

Thread: Unused Column

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    We found an UNUSED COLUMN in a table, but we actually didn't mark any column as UNUSED on that table explicitly. We did drop a unique contraint and created a unique function based index on that table.

    Does any body know that any side effect could result in a column getting UNUSED mark.

    Thanks for any help.
    zm

  2. #2
    Join Date
    Apr 2001
    Posts
    108

    unused column

    A column marked as unused may still have data, but the column name will not be displayed in queries or data dictionary views. The name is removed from the data dictionary so that a new column can reuse that name. All constriants, indexes and statistics defined on the column are also removed.
    Eric Hanson

    There are 10 types of people in the world:

    Those who understand binary and those who don't!

  3. #3
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Sounds strange ..

    Unused columns as good as deleted columns

    They cannot be accessed
    Then cannot be exported

    Sridhar R Patnam

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Yes if the UNUSED column hasn't affected any processes in your application and database, I'd say it'd be safe to drop. When DROP the unused column, just remember no DML can be performed on the table whilst this is occuring.. and if its a large table, that can take a while.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

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