Oracle Database Data Pump 1. Datapump steps
Example
| Source Server [Export Data] | Target Server [Import Data] |
|---|---|
| 1. Create a datapump folder that will contain the export dump files | 4. Create a datapump folder that will contain the import dump files |
| 2. Login to database schema that will perform the export. | 5. Login to database schema that will perform the import. |
| 3. Create directory pointing to step 1. | 6. Create directory pointing to step 4. |
| 7. Run Export Statements. | |
| 8. Copy/SCP the dump files to Target Server. | |
| 9. Run Import statements | |
| 10. check data ,compile invalid objects and provide related grants |
