Backup and restore Oracle databases with PL/SQL Devoloper

Steps:

1 Export (Backup) Build table statements, stored procedures, triggers, sequences, and all user objects. The. sql file is exported

Select all exported objects and select the path to export

2 export (Backup) table structure and data. Exported as a. dmp file

Also select the path of the object and output file that you want to export

Note You need to restore the DMP file first

3 Restore (Restore) table data. Importing. dmp files

Select the path to the user and backup files to import to

4 restore (restore)   other objects (stored procedures, triggers, sequences, functions, etc.)

plsql Login to the database to be imported,

Backup and restore Oracle databases with PL/SQL Devoloper