Home » SQL & PL/SQL » SQL & PL/SQL » Column dropped (11 g )
Column dropped [message #656939] Mon, 24 October 2016 08:30 Go to next message
saipradyumn
Messages: 320
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 #656940 is a reply to message #656939] Mon, 24 October 2016 08:33 Go to previous messageGo to next message
BlackSwan
Messages: 25858
Registered: January 2009
Location: SoCal
Senior Member
I hope you have good backups
Re: Column dropped [message #657219 is a reply to message #656940] Wed, 02 November 2016 01:12 Go to previous messageGo to next message
saipradyumn
Messages: 320
Registered: October 2011
Location: Hyderabad
Senior Member

Yes, we have the back up in another data base.I am trying to update the required column based on Primary key with help AbIntio.
Re: Column dropped [message #657252 is a reply to message #657219] Wed, 02 November 2016 14:59 Go to previous message
Bill B
Messages: 1718
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

Previous Topic: Default Character type of the column
Next Topic: How to format JSON column
Goto Forum:
  


Current Time: Fri Feb 23 08:00:39 CST 2018

Total time taken to generate the page: 0.09764 seconds