Oracle Flash back ____oracle

/*
Quick Flashback
    PROCEDURE
    PACKAGE
    PACKAGE body
    type body
    TRIGGER
    FUNCTION
    type
 
  1. Use the SYS administrator
  to log in 2. Command Window execution (for easy access to data, will retrieve the data stored in TXT format, set pagesize large enough to avoid data segmentation)
     sql> spool D:\1234566789.txt
     sql> set pagesize 2500           
     Sql>select text 
         from Dba_source as of timestamp to_timestamp (' 2013-09-24 16:30:00 ', ' yyyy-mm-dd HH24:MI:SS ')-- The data
         where owner = ' Scott '--user and
         name = ' EMP '-    -stored procedure name and  type = ' PROCEDURE '-  -in front of the flash-back time node The flash-back stored procedure order by line
         ;
  3. Open D:\1234566789.txt, remove the separator in the build process, you can
* *