Can We Restore a Table that accidantly dropped.
- 8 Answers
- 16149 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / chintan_db
create table dropedemo(a number(10)); --will create table
commit;
insert into dropedemo values (dbms_random.value(0,100)) ; --
data inserted
commit;
drop table dropedemo; --drope table
flashback table dropedemo to before drop; --will restore
table
select * from dropedemo;
--will create magic and give u proof of data is back
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
