oracle恢复误删的procedure存储过程

如果10分钟不小心刚刚误删了一个procedure，又没保存脚本，现在如何恢复? drop procedure必然delete dba_source,delete 当然会想到闪回查询
sql>conn test/test
sql>drop procedure p_user;
SQL> select text,name from dba_source where owner='TEST' and name='P_USER';
no rows selected
SQL> select text from dba_source AS OF TIMESTAMP SYSDATE-15/60/24 where owner='TEST' and name='P_USER';
TEXT
--------------------------------------------------
procedure p_user
is
begin
insert into test_pro(id,name,insertdate) values(us
erenv('SESSIONID'),user,sysdate);
end;
都找回脚本了，怎么恢复不多说了，重建吧！