Results 1 to 9 of 9

Thread: Recovery form Deletion

  1. #1
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Recovery form Deletion

    Two days before i updated rows in a table and commited .But I want original status of my updated table is it possible ... if so ..help me with a query.


  2. #2
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Recovery form Deletion

    What is the verison of oracle that you are using ?


  3. #3
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Recovery form Deletion

    I am using Oracle 10g


  4. #4
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Recovery form Deletion

    Try using flashback queries using SCN.


  5. #5
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Recovery form Deletion

    I used following set to get original table,but table status is not changed.
    select Dbms_flashback.get_system_change_number from dual
    Alter table emp enable row movement
    flashback table emp to scn(6082173321)
    pls solve it


  6. #6
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Recovery form Deletion

    try the following sample code

    Code:
    select * from dept as of timestamp (sysdate-2)



  7. #7
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Recovery form Deletion

    also try this for more specific time

    Code:
    SELECT * FROM emp AS OF TIMESTAMP TO_TIMESTAMP('2007-10-18 17:27:12', 'YYYY-MM-DD HH24:MI:SS');



  8. #8
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Recovery form Deletion

    select * from emp as of timestamp (sysdate-2) By using this an error occur
    i.e., ORA-01555: snapshot too old: rollback segment number 22 with name "_SYSSMU22$" too small


  9. #9
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Recovery form Deletion

    That is because your rollback segment is too small so the transaction details is deleted from there also .Now you can't use the specified command.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact