Recover deleted Page with APEX and Firebug

Today a very important Page of an important APEX Application has accidentially been deleted. We didn’t want to step back to yesterdays backup, because right before the deletion many changes took place and we didn’t want to code that again.

Oracle APEX includes the realy nice feature of exporting an Application “As of x minutes ago”.

But there is also a dialog where you can export a single page, without the whole application overhead:

But this dialog lists only currently existing Pages and doesn’t include our deleted Page.

Firebug to the rescue we manipulate the HTML-Code of the Page-Select-List and add our deleted Page 99 which then exports easily “As of 30 minutes ago”.

1. Use Firebugs “Inspect Element” on the Page-Select-List

2. Edit the HTML and insert a new <option>

3. pick the newly added entry from the select-list, enter 30 as number of minutes and press the export button

4. go to the import menu and import the Page-Export File.

That’s all.

Life can be sooo easy using the right tools :-)



  1. Tobias Arnhold on November 8, 2011

    Hi Peter,

    what a smart idea. Thanks for sharing this. I guess I will need some day. :)

  2. Tyler Muth on November 9, 2011

    Nice use of Firebug and flashback. I added the export as-of feature to apex back in the day. It’s not perfect, but better than nothing. Here’s a different twist on your technique using SQL Developer. Each has it’s advantages:
    http://tylermuth.wordpress.com/2007/11/17/apex-flashback-sql-developer-undo/

  3. Peter Raganitsch on November 9, 2011

    Hi Tyler,

    thanks for reminding me of that post, another great use of tools!

  4. James Chapman on January 13, 2012

    That post just saved me hours of work.
    Thank you!!!

  5. Omar Sawalhah on April 10, 2012

    Hi Peter,
    Thanks a lot, you will not believe this, I just deleted, accidentally, a page that I have being working on for more than two days. I used your trick and did the work perfectly.

    Thanks
    Omar

  6. […] the thread on OTN, I had a look on Google to find out more on this matter. I came across a great article of P. Raganitsch that demonstrates how easy it is to recover a deleted page. This article however […]

  7. tushar on November 20, 2012

    Thanks a lot!!!!!!!!!!!!!!!
    I am really impressed from your logic. I am trainee in apex and i had deleted one important page accidentally. So by using this trick i can rollback it.
    Thanks again from bottom of my heart

  8. Peter Barry on June 7, 2013

    My girlfriend’s gonna bake you a cake!!
    You saved our weekend.

    Many thanks.

  9. Peter Raganitsch on June 7, 2013

    Chocolate, please :-)

  10. Maurice on March 9, 2014

    Wow, what a great trick. you saved the day, THANKS!!!

  11. ahmed on April 1, 2014

    not working for me. After importing iam getting error as follows

    Contact your application administrator.
    Error ERR-1016 Application “102” Page “4” not found (requested language=”en”)

  12. Peter Raganitsch on April 3, 2014

    Are you trying to import the page into the same application you exported it from? Same System, same workspace, …?

  13. Kylie on September 17, 2014

    Oh thanks! This saved me hours of work recreating a page from scratch!

  14. brenda on November 12, 2014

    thanks a million this really helped :-)

  15. […] For a full step by step explanation , see the original post by Peter raganitsch […]

  16. RICHARD on July 20, 2016

    THANK YOU . THANK YOU . THANK YOU . !!!!!!!!!!!


0