Restore only a PDB is simple - Test done in Oracle Cloud

If you dropped a table and want to restore to a restore point for example just run these commands below:

    set decryption identified by oracle;
    alter pluggable database MYPDB close;
    restore pluggable database MYPDB to restore point myrestorepoint;
    recover pluggable database MYPDB to restore point myrestorepoint;
    alter pluggable database MYPDB open resetlogs;

I tested it using a cloud database and a cloud database backup in Oracle Cloud. Everything works perfectly.


Best Regards,
Paulo Portugal