Oracle 12.2 came with a new feature , we can simply recover a single table in a database.

In below example we will see how we can restore a table of pluggable database.

Step 1 : Connect to RMAN

Step 2 : Use following command to recover table I.E. here I have table TEST which I want to restore in TESTPDB pluggable database.

Note : You can give specific SCN until where you want to recover table

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.