Exporting certain tables with criteria using datapump

I thought it will be nice to share this little trick to you who is asked to copy tables from one database to another but only tables start with some criteria. You probably will try datapump using parameter 'INCLUDE=TABLE:"like 'PE_%'"' but if you are asked to copy more than one table criteria you can't simply …

Side note when doing duplicate database

Recently I got an issue where someone mistakenly deleting data on production database. The size of the database is close to 2TB. The business users would like to get the data back. Unfortunately the issue reported 2 weeks after the incident which I can't perform flashback of the table. The option I had is to …