-
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
-
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!
-
Sounds strange ..
Unused columns as good as deleted columns
They cannot be accessed
Then cannot be exported
Sridhar R Patnam
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|