Comments
| Dropping Columns - Hide unused columns or completely remove them. |
aru said... it's very useful.thanks |
Master said... It was excellent |
adesh said... useful to increse the basic knowledge about oracle |
Ravindranath said... Super Boy |
ROUNAK said... hey its givin an error that is" resource busy and acquire with NOWAIT specified" wht to do to overcome it.. plz reply on rounak182003@yahoo.co.uk.. its urgent!! |
ROUNAK said... hey its givin an error that is" resource busy and acquire with NOWAIT specified" wht to do to overcome it.. plz reply on rounak182003@yahoo.co |
ROUNAK said... hey its givin an error that is" resource busy and acquire with NOWAIT specified" wht to do to overcome it.. plz reply on rounak182003@yahoo.co.uk.. it |
Vijesh said... I have got queries in the topic under discussionalter table TABLE_VIJESH add ( COL_1 varchar2(10)) alter table TABLE_VIJESH set unused (COL_1)/*it logically deletes the column*/ select * from DBA_UNUSED_COL_TABS where TABLE_NAME = 'TABLE_VIJESH' /*gives result*/ OWNER TABLE_NAME COUNT IRS_MIG 'TABLE_VIJESH' 1 alter table TABLE_VIJESH add ( COL_1 varchar2(10)) alter table TABLE_VIJESH set unused (COL_1) Query: 1) The same coulmn set unsued is added in the table and later made unused.Its allowing but select * from DBA_UNUSED_COL_TABS where TABLE_NAME = 'TABLE_VIJESH' /*gives result*/ OWNER TABLE_NAME COUNT IRS_MIG 'TABLE_VIJESH' 2 Query 2: The count shown is 2, i.e 2 columns(with same name) have been marked unsued on a table, How could this be?? On a table two columns with same name cannot exist, so how could 2 columns for a single table is recorded in DBA_UNUSED_COL_TABS ?? |
Tim... said... Hi.Please ask questions in the forum, not in the comments. Regarding your questions, it's a feature. You can;t have two columns with the same column name, but once you mark a column as unused the column name is free to be reused again, and again, and again... Cheers Tim... |
DO NOT ask technical questions here, that's what my forum is for!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!