Import and export of Oracle databases

The import and export of Oracle database is an important technical work, not only solves the import and export of the database, but also makes it easier and quicker to obtain the data.

Import and export data using imp and exp

Exporting data using exp

Storage directory for \oracle_home\bin

Exporting dmp files

Three ways to export are supported:

Table method to export a specified table

User mode exports all objects belonging to a user, which is the default option

All objects in the database are exported in a full database, only the DBA can

Import data using imp

Storage directory for \oracle_home\bin

Import/Export data using PL/SQL developer

650) this.width=650; "src=" Http://images0.cnblogs.com/blog2015/750492/201505/142107197202486.png "style=" border:0 px; "/>

Export exp epet/[email protected] table=pet file=d:\desktop\pet.dmp (export path)

650) this.width=650; "src=" Http://images.cnitblog.com/blog2015/750492/201505/132135090799474.png "style=" border:0 px; "/>

Import imp epet2/[email protected] file=d:\desktop\pet.dmp full=y (full=y: Export all data)

650) this.width=650; "src=" Http://images.cnitblog.com/blog2015/750492/201505/132135257043362.png "style=" border:0 px; "/>

The is extremely heavy of responsibility is a long way to go.

Import and export of Oracle databases