Oracle Database Import and Export, oracle Database Export

Oracle Database Import and Export, oracle Database Export

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

You can use the exp export data storage directory \ ORACLE_HOME \ BIN to export the dmp file. You can use the table method to export a specified table user to export all objects belonging to a user, it is the default option to export all objects in the database in full database mode. only DBA can use imp to import data to the \ ORACLE_HOME \ BIN directory and 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)