Problem Statement: Restore entire database using Data Pump. Restore table(s) Restore tablespace(s) Restore schema(s) Restore using Transportable tablespaces (TTS) Restore from multiple small sizes of dump files Restore in parallel mode Originally written covering Oracle 11g/12c Data Pump. The impdp command syntax and parameters remain valid through Oracle 19c and 21c. Newer versions have added Read more about Data Pump: impdp[…]
Problem Statement: Backup entire database using Data Pump. Backup table(s) Backup tablespace(s) Backup schema(s) Backup using Transportable tablespaces (TTS) Generate multiple small sizes of dump files Backup in parallel mode Approach: There are single shot solution to all the above problem statement and it is Data Pump. It is one of various backup tools provided Read more about Oracle Data Pump: expdp & impdp[…]
Among various techniques of backing up your database Oracle provides data pump as one of tool which they are constantly improving and making this tool sharper release by release. Data Pump was introduced in Oracle 10g as a replacement for exp/imp. This post covers the concepts that remain valid through Oracle 19c and 21c. For Read more about Data Pump: a tool to backup and restore database[…]