Restore FND_NODES table entries if the table deleted accidently
-----------------------------------------------------------------------------------
create table applsys.fnd_nodes_temp1 as select * FROM applsys.fnd_nodes AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '60' MINUTE);
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
insert into applsys.fnd_nodes select * from applsys.fnd_nodes_temp1;
Ref: Oracle Flashback Query: Recovering at the Row Level(https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr002.htm)
Example:
INSERT INTO EMP
(SELECT * FROM EMP AS OF TIMESTAMP
TO_TIMESTAMP('2005-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS')
WHERE name = 'JOHN');
-----------------------------------------------------------------------------------
create table applsys.fnd_nodes_temp1 as select * FROM applsys.fnd_nodes AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '60' MINUTE);
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
insert into applsys.fnd_nodes select * from applsys.fnd_nodes_temp1;
Ref: Oracle Flashback Query: Recovering at the Row Level(https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr002.htm)
Example:
INSERT INTO EMP
(SELECT * FROM EMP AS OF TIMESTAMP
TO_TIMESTAMP('2005-04-04 09:30:00', 'YYYY-MM-DD HH:MI:SS')
WHERE name = 'JOHN');