Column dropped [message #656939] |
Mon, 24 October 2016 08:30 |
|
saipradyumn
Messages: 419 Registered: October 2011 Location: Hyderabad
|
Senior Member |
|
|
Hi All ,
By mistake I had dropped the one of the column on table which contains huge data.
Is there any way to get the column with my previous data .
FLASHBACK feature is disabled for that session
Please help me
|
|
|
|
|
Re: Column dropped [message #657252 is a reply to message #657219] |
Wed, 02 November 2016 14:59 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
if you have the data in another database then put the column back into the table and then using a database link to the other databse simply do an update into your replaced column. for example (pseudo code)
update my_table a
set a.replaced_column =
(select b.replaced_column
from my_table@other_DB b
where a.primary_key = b.primary_key);
commit;
[Updated on: Wed, 02 November 2016 15:00] Report message to a moderator
|
|
|