Table recover

drop table roy.persons.


select object_name, original_name, type from dba_recyclebin;

connect to users.

flashback table persons to before drop.

select * from tab;

ALTER TABLE OME.W_RP_ADJ_F ADD (

INS_DT  TIMESTAMP(3),

LAST_UPD_DT  TIMESTAMP(3),

IS_ACTIVE VARCHAR2(1 CHAR)

);

ALTER TABLE OMG.KVI_ADJNTS_HCL_HIST ADD (

INS_DT  TIMESTAMP(3),

LAST_UPD_DT  TIMESTAMP(3));