2 Replies Latest reply: Oct 8, 2013 3:04 AM by RHELSENSEI RSS

    Drop tablespace and flashback : ORA-01245: offline file 7 will be lost if RESETLOGS is done

      Hello,

          1 create tablespace TS1
          2  create restore point RP1;
          3 drop tablespace TS1 (datafile  '/c:/ts1.dbf')  including files
          4 restore database to RP1
          5 alter database open resetlogs failed with this error :
              ERROR at line 1:
        ORA-01245: offline file 7 will be lost if RESETLOGS is done
        ORA-01110: data file 7: '/c:/ts1.dbf'

         Can you help me please to fix this issue and to understand why it's occured.