Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

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 discussion

alter 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...

daud said...

Thanks very usrful
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired