Undo a dropped Column from a table/forum/mv/msg/188601/590004/#msg_590004
Flashback query is working fine for dropped table,but throwing error when trying to get back the previous date by dropping a column from a table.

Is that a limitation of Oracle by not having query to flashback a column but a table.

Regards,
Nathan]]>sss111ind2013-07-13T13:14:55-00:00Re: Undo a dropped Column from a table/forum/mv/msg/188601/590007/#msg_590007
John Watson2013-07-13T13:46:12-00:00Re: Undo a dropped Column from a table/forum/mv/msg/188601/590008/#msg_590008
Flashback query is perfectly working for DROP TABLE even it is a DDL statement.Because flashback query does not recreates the table which is dropped but gets it from recycle bin and then performs a set of DML statements.So why it unable to do in case of DROP COLUMN.

Regards,
Nathan]]>sss111ind2013-07-13T14:12:23-00:00Re: Undo a dropped Column from a table/forum/mv/msg/188601/590009/#msg_590009
If you want equivalent functionality for a column, the closest is ALTER TABLE...SET UNUSED COLUMN...; but Oracle has not provided syntax to reverse this, though you can see it as a hidden column in dba_tab_cols.