Import and export of Oracle databases

Import and export of Oracle databases

The import and export of Oracle databases is an important technical activity, which not only solves the import and export of databases, but also facilitates and quick data access.

Use imp and exp to import and export data

Export data using exp

The storage directory is \ ORACLE_HOME \ BIN.

Export dmp files

Three export methods are supported:

Export a specified table

Export all objects belonging to a user in user mode, which is the default option

Export all objects in the database in full database mode, only DBA can

Use imp to import data

The storage directory is \ ORACLE_HOME \ BIN.

Use PL/SQL Developer to import/export data

Export exp epet/epet @ orcl table = pet file = D: \ desktop \ pet. dmp (export path)

Import imp epet2/123 @ orcl file = D: \ desktop \ pet. dmp full = y (full = y: export all data)

---------------------------- Lili split line ----------------------------

Oracle Import and Export expdp IMPDP details

Solution to Oracle 10g expdp export error ORA-4031

Oracle 10gr2 rac expdp error UDE-00008 ORA-31626

Use of expdp/impdp to back up databases in Oracle

Oracle backup recovery (expdp/impdp)

---------------------------- Lili split line ----------------------------